K
Kathy
I would like to enter data in one table using information
from another field. For example, I have a table called
Retailer. It contains Retailer ID, Retailer
name,Retailer Rebate,etc. I also have an Order table. I
would like to fill in fields in this table by looking up
records in the first table. I have used a combo box to
look up each field individually but I would be better if
I could fill all related fields at once. Does anybody
know how I can do this?
from another field. For example, I have a table called
Retailer. It contains Retailer ID, Retailer
name,Retailer Rebate,etc. I also have an Order table. I
would like to fill in fields in this table by looking up
records in the first table. I have used a combo box to
look up each field individually but I would be better if
I could fill all related fields at once. Does anybody
know how I can do this?