Runing a query that fills in field

[Guest]

Here is my situation.
I have two tables Inventory and Invoice.
They are linked by order number
I am trying to import old data into the database, however most of the old
data is just invoices and does not include any inventory (for reasons
unknown) and my forms are set up to search iventory (with invoices being a
subform link)

Therefore all of the invoices without inventory do not come up.

What I think I need to do is run a query that updates the inventory table
with all of the corresponding order numbers that are not currently in the
table. Then I can assign a default value to all the null values of say the
"product name field" so that all the invoices will come up when the users use
the forms.

 

[Pat Hartman \(MVP\)]

No, populating dummy records isn't the solution. You need to change your
query to use a Left or Right (as the case may be) join. That will allow the
query to bring back invoices even if there is no inventory associated with
them.

 

[Guest]

Thanks for the responce. If you have time would you please explain how to do
a left/right query join.

Thanks!

 

[Pat Hartman \(MVP\)]

Open the query in design view.
Right click on the MIDDLE of the join line to bring up the join dialog. If
you get the properties dialog, close it and try again.
Choose either type 2 or type 3 depending on which makes sense for your
situation.
Save the query.