[AccessD] Lookup field in table

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Jun 2 08:20:42 CDT 2009


I have a table with the first two fields being named PIDName and Ptype. The third field is named PID. I would like the field PID to be automatically populated with the PID that corresponds with the PIDName entered by the user. The PID is stored in a different table (CompletionMaster). I have tried a lookup field but it returns all values in the CompletionMaster table. Is this possible?

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.





More information about the AccessD mailing list