Help on Lookup

[sk5347]

Hi,
I have 2 tables 1 caled tblCustomers and the other tblQuote.


In the tblCustomers I have 5 fields which are common to the tblQuote.
What I would like to do is in the frmQuote insert the Pid in to the Pid field and it will bring in the other 4 fields from the tblCustomers.
Am i looking to create a lookup on the Pid on the frmQuote or is it something else I should be looking at.

Any help would be great.

Keith

[pbaldy]

One way:

http://www.baldyweb.com/Autofill.htm