Is it possible to Load Values into a Table from a query

[Karlperkins12345]

I have a problem Im trying to fill in A Order table with Information based on a Suplier Table I was wondering If it was possible to load the data just by Selecting the Supplier name using a Combobox lookup and then having it fill in the Rest of the supplier info

 

[LittleSmudge]

I think what you're asking for is an Append query.

Though I would strongly urge you to consider your Normalisation Rules if you are even thinking of duplicating data from one table into another like you seem to be implying.



G LS