lookup

[steve111]

hi , I have attached a from which is called
"invoicedata" this form has a column " Customername "
the first name is "Alstom - Transport"
There is a table called customer
the id number for the customer "Alstom - Transport" is 200

how can I get the e-mail name into the invoicedata form

thanks
steve

 

[plog]

Actually that database only has 2 tables and no other objects. So, I'm not entirely clear what you want. If you want to display the shipping data in the form and also include a field that has the customers email you would use a Dlookup (http://www.techonthenet.com/access/functions/domain/dlookup.php) on an unbound field in that form using the ID of the record in the criteria argument of the Dlookup.

If you want the email address to appear alongside the data from the shipping table, for that you would use a query, linking the two tables by customer ID and bringing in all required fields.

 

[steve111]

hi,

I just want to include the e-mail address in the form invoicedata by looking at the customername in the invoicedata form and checking it against the name in the customer table

so I though it would be a look up but I have no idea how to do it

thanks
steve

 

[steve111]

sorry , did not know tables where hidden