how can i combine 3 table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mezzanine1974 - 07 May 2007 14:03 GMT

lets say we have 3 storey building in use. At each floor, there are
several type of furnitures. So we have produced 3 seperate table which
has only one field called `furniture name`.
I would like to see furnitures in a single table (query result) which
will have 3 fields (Floor1, Floor2 and Floor3).
If, for example, `Furniture A` exist on only Floor3, Query result will
be null for Floor 1 and Floor2, but Floor3.
Thanks for your support.

Reply to this Message

Jeff Boyce - 07 May 2007 15:08 GMT

I'll urge you to reconsider your design/approach. What you described sounds
like a spreadsheet, not a relational database (i.e. Access).

Instead, consider a table design that looks something like:

trelFurniturePlacement
FurniturePlacementID
FurnitureID (what piece of furniture, from the tblFurniture table)
FloorNumber

This design doesn't require "blank" fields, as there will be only one record
per furniture/floor combination.

Signature

Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

> lets say we have 3 storey building in use. At each floor, there are
> several type of furnitures. So we have produced 3 seperate table which
[quoted text clipped - 4 lines]
> be null for Floor 1 and Floor2, but Floor3.
> Thanks for your support.

Reply to this Message