names and addresses

[antonov]

hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and fax
numbers and email addresses. Another table with the Consignee's contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the problem:
Is it possible to make the address and all the other data appear in my text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after input?
thanks

 

[Guest]

Hi Antonov,

Check out the Orders form in the sample Northwind database. Add a new order,
by selecting a customer from the Bill to dropdown. Is this the type of
functionality that you are wanting?


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

hello everybody:
I have a table (Consignee) with contacts, their addresses, tel and fax
numbers and email addresses. Another table with the Consignee's contacts
(Consignee_contacts).
I have a form (Operations) in which I can input some data. Now the problem:
Is it possible to make the address and all the other data appear in my text
boxes if the name of the consignee is already in the table?
If the name is not in the table is it possible to save it after input?
thanks