Multi-selection

[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

 

[John Vinson]

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?

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.

 

[TC]

Adding to what John said, you need to read:

http://support.microsoft.com/support/kb/articles/Q100139.ASP

HTH,
TC

 

[John]

Thanks. I should have realized that for myself. Oh well.