hey i put together some example data...hopefully it makes sense i didn't know how else to write it out


TABLE category

cat_id | cat_name

1. 1 Bedroom
2. 2 Bathroom
3. 3 Kitchen
4. 4 Living Room
5. 5 Office
6. 6 Garage
7. 7 Family Room
8. 8 Property
9. 9 Attic
10. 10 Basement



TABLE postalcode

postcode | cat_name | status

1. B0H Bedroom used
2. X1A Bathroom used
3. X1A Kitchen used
4. R4A Living Room used
5. G2M Office used
6. B0H Garage used
7. R4A Family Room used
8. G3A Property used
9. B0H Attic used
10. X1A Basement used


thanks