Lookup ID#, etc. in tables

[savegelt]

1. I have a table :"BuyerSeller" it has ID#, Company, Contact, Tel, City State, etc.( I keep track of all my BuyersSellers info in here
I have another table called "BuyerWants" (every time a Buyer has a new need for me to find an item I would post it here) I go into the field called Buyer which is a ComboBox(i pull up the Buyer Name from here). How do get the ID#, Contact, Tel #, Email to lookup in the "BuyerSeller" and drop into my "BuyerWants" table for viewing

2. I want to design a quotation report. I would like to do it in Form View, where I pull up the "Buyer" (combo box), It auto places date/time, auto adds quote number, & I can pull up my asset equipment "list" and it drops in the ID, Make, model, specs, etc. It will then go nto my Quote Log Table I can then go into a Tag field (yes/no) and create a query for printing the Quote reports( one page per item{has 30 different item charcatersistics I.e- size, make, model, capacity, HP, RPM, weight, dimensions, voltage,etc

3. I want to create an action log where I can keep a history for each contact

 

[Tim Ferguson]

1. ...
I go into the field
called Buyer which is a ComboBox(i pull up the Buyer Name from here).
How do get the ID#, Contact, Tel #, Email to lookup in the
"BuyerSeller" and drop into my "BuyerWants" table for viewing?

To see them in the control, you use the RowSource property of the combo
box: create a query that has the BuyerSellerIDNumber in the first column
and whatever you want to see after that, sorted on something useful.

You would not want to copy the extra fields from BuyerSeller into
BuyerWants because you would never be able to keep them in synch. When you
want to see details of wants next to details of buyers, then you use a
query that joins the two tables. Much easier and more reliable!

2. I want to design a quotation report. I would like

Fine: what is the question?

3. I want to create an action log where I can keep a history for each
contact

Okay: what is the question again?

B Wishes


Tim F