If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup ID#, etc. in tables
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 |
#2
|
|||
|
|||
Lookup ID#, etc. in tables
"=?Utf-8?B?c2F2ZWdlbHQ=?=" wrote in
: 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 |
Thread Tools | |
Display Modes | |
|
|