database design (1 Viewer)

Hi

i havent been on Access for a while so im still in the process of getting the cogs turning....... i am trying to design a database structure for controllers and heating.

each controller can have many heating units
each heating unit can use many controllers

rather than code everything, how could i set this up?

Example:
Controller01 can be used with Boiler01, Boiler04, Boiler12, Boiler 20
Controller02 can be used with Boiler01, Boiler05, Boiler15
Controller03 can be used with Boiler02, Boiler03, Boiler04, Boiler20

i have a table with a ControllerID and a table with a BoilerID. In the boiler table, i have the ControllerID and a one to many relationship.

how would i set this up?



Thanks


NIgel

Junction table to the rescue (http://en.wikipedia.org/wiki/Junction_table). To define a many to many relationship, you use a third table to do so.