I am desinging a data entry form which enters some data in table "quote".
There are 3 tables in my database
Products, Customers, Quotes
Structure of Quotes Table.
QuoteId (Autonumber)
CustName(Text)
PartNo (Lookup)
Description (Text)
Price (Number)
At first I have to enter Customer Name and then PartNo which is a lookup
field from products table.
CustName is either present in customers table or a new entry. My concern is
whenever a new customer is entered in quotes table, i want customer name
automatically entered in customers table as well.
I dont know how to update other table while making data entry. Someonw please
help.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200608/1
|