Connecting multiple tables to one form

[JenPur2002]

I have been working towards getting a DB Inventory setup for all our
recievables within our shipping/recieving department to account for
everything that comes in and to relay back to our finance department on what
is REALLY being spent. The coolest thing about this form is that it is
supposed to later on be able to link to an API (future goal of our company)
enabled tool where everything is web-based. What Im wanting is to have one
form, something that is easy for everyone to use. And within that form have
drop-down fields for us to select from that is going to put all the contact
information that we are needing into the correct fields. The only reason Im
doing that is to cutdown on the amount of keystrokes entered into the DB when
it is completed. Those drop-down fields are Vendors, Department, Buyer. My
issue is, I cant figure out how to connect the 3 tables that have all the
information needed to the actual form I would like to use.

Do I need to make this DB into a multiple form database or is this ok??

Thanks soo much!!

 

[Douglas J. Steele]

Multi-table queries are very often not updatable.

Consider using multiple forms (as subforms) on a single parent form.

 

[JenPur2002]

ok, thanks so much, i wasnt sure....

Multi-table queries are very often not updatable.

Consider using multiple forms (as subforms) on a single parent form.

 

[John W. Vinson]

Those drop-down fields are Vendors, Department, Buyer. My
issue is, I cant figure out how to connect the 3 tables that have all the
information needed to the actual form I would like to use.

I'm not at all sure what you're asking. What is the structure of your table?
Do you have a VendorID, DepartmentID, and BuyerID in the table upon which your
form is based? Do you have relationships defined between your main table and
these tables?

If so, use the Combo Box wizard on the form design toolbox to add combo boxes
to your form. These will store the vendor ID while displaying the vendor name.

Do I need to make this DB into a multiple form database or is this ok??

ummm... it's a pretty trivial database that contains only one form. Sure,
you'll want multiple forms - is that a problem??

John W. Vinson [MVP]