Pulling Info from a seperate Table

[Terry]

I am creating a form to enter purchase orders into the orders table. I want
to pull info from the suppliers table also. I know I can use a subform to
display the data, but I want to actually capture several fields from the
suppliers table to enter into the orders table with the order. Can anyone
point me to a resource to read how to do this?

Sorry - I know this is pretty basic stuff, but any guidance would be
appreciated.

Terry

 

[Golfinray]

If there is something common to both tables, you would create a query, pull
in both tables, and hook them up. Now you could create the form without
havinbg to use subforms. The problem will occur if there is nothing in
common, like an ID number, order number, customer number or the like that is
used in both tables. If there is nothing in common, you would probably have
to use a union query. Search under "queries" and you should be able to get a
lot of examples.

 

[Terry]

Thank you for the reply,

I obviously need to do some testing on my end so I know what I am talking
about. I did not think basing the form on a query would work because an
inner join would not return new vendors that did not have associated records
in the orders table, and if I made it an outer join to force all of the
vendors to be returned, then I thought the query would not be updateable.

Thanks for the help - I will do some testing and come back if I need more
help.

Terry