Edit fields in an outer join query

[ehamike]

I have 2 tables (tblItemsQB and tblItemInfo) that have a 1 to 1 relationship linked by the "PartNumber" field. The tblItemsQB table contains a description field and 2 price fields (this table is downloaded from Quickbooks). The tblItemInfo table contains additional fields with information on the part that isn't contained in Quickbooks, like OrderType, Phase, SubSystem.

I import the items from QB into tblItemsQB and then do an outer join with tblItemInfo to link all the information for the part. If I have created a new part in Quickbooks, when I do the outer join (I include all records from tblItemsQB) I can see the new part but since the part number doesn't exist yet in tblItemInfo, I can't add the information to the fields in that table.

What is the easiest way to create the new PartNumbers (those that exist in tblItemsQb but not in tblItemInfo) in the tblItemInfo table so I can add the other information to it?

thanks
mike

 

[neileg]

You would normally do this in a form/subform setup. tblItemInfo would populate the subform. In your case you will have one record or a blank record in the subform. Access will manage the parent/child links so that when you start to populate the blank record, it supplies the value for the foreign key filed in tblItemInfo automatically.

 

[ehamike]

thanks
I'll set it up that way instead of running the query first