I have a set of queries, based on one table, that I use to filter the information I want. I need, once I have the information on a pop up form, so that I can verify it is right, to have the ID number added to another table, as a new record or an existing record. What I mean is: I have a tblPO (purchase order). This is either a new record or an existing record, depending on the purchase order number. When I want to insert info, ie: trucking company, shipper, receiver, customer, I call up a query from my tblContactList. Once I have queried the proper info, I want just the ID number to insert itself into the tblPO, which will then requery the information required for the printing of the PO. My problem seems to be from the fact I use only one tbl for all my contacts, as a trucking company can be a shipper, receiver or customer and a shipper can be a receiver or customer, etc. If my relationship was clear cut on who each contact is, I could divide my contact list up, but this is not the case. Any suggestions. BTW, each record in the tblPO must have a trucking company, shipper, receiver and customer. Thank you in advance for any advice you might give me.
