lookup field

[cofitanner]

hey..

i makeing a invoicing system for a m8z new business and am trying to make it so that when he fills in a form for the invoice, when the Customer ID cell is filled that the other fields automatically fill using the data from the customer table..

so basically i have:

customer TABLE
invoice TABLE

so when they enter customer ID i want name,address,telel etc etc to auto fill..any ideas?

thanks

 

[A|ex]

the dlookup command will work

 

[cofitanner]

wot and how do i do that?

 

[dan-cat]

DLookup() is the worst possible solution. Take a look at the samples Here

...and the laziest

 

[dan-cat]

I guess that's why Microsoft uses it so frequently in its examples.

It keeps the masses quiet