Multi-selection

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi,
I have a valve that can appear on more than one drawing
number. The drawing number field on the device table is a
lookup to the drawing number table. Is there a way to put
more than one choice in the drawing number field so to
have the valve only show up once? Or is there a better
way?

Thanks
 
Hi,
I have a valve that can appear on more than one drawing
number. The drawing number field on the device table is a
lookup to the drawing number table. Is there a way to put
more than one choice in the drawing number field so to
have the valve only show up once? Or is there a better
way?
Click to expand...

If a Drawing can contain many valves, and a Valve can appear on many
drawings, then you have a typical many to many relationship. The way
Access (or any) relational database handles such relationships is by
adding a third table, with fields for the DrawingNumber and ValveID.
You'ld enter one record in this table for each valve on each drawing.
 
Back
Top