Many-to-Many relationship question

[b9791]

I have a property management work order database with a table for properties, units and tenants. I need to be able to expand/split units. Will this require a many-to-many relationship and if so, what tables are in the relationship?

Brian

 

[RV]

Will this require a many-to-many relationship

No.
Why do you ask?

RV

 

[b9791]

No.
Why do you ask?

RV

I'm just not sure how exactly to set it up. How do I keep the unit history . For example a property with Units A, B, & C has a tenant move in that will be utilizing all three units and using only the address for Unit B. These are now a single unit, but I still need to be able to look them up as an individual and see that they are merged with unit B.

 

[b9791]

I'm just not sure how exactly to set it up. How do I keep the unit history . For example a property with Units A, B, & C has a tenant move in that will be utilizing all three units and using only the address for Unit B. These are now a single unit, but I still need to be able to look them up as an individual and see that they are merged with unit B.

Nevermind...I think I have something figured out.

 

[ssteinke]

Brian,

Sounds to me like you are trying to set up a Junction Table. That would combine the primary keys of different tables to make the primary key of your new table, allowing you to construct your many-to-many relationship.

http://support.microsoft.com/?kbid=304466

hope this helps,

Scott