[AccessD] Lookup field in table

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Jun 2 10:26:56 CDT 2009


Just what I was thinking but wanted an expert opinion. Thanks

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Tuesday, June 02, 2009 9:57 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Lookup field in table

This is the kind of thing you do with code in a form.  Tables can't automatically populate a field based on another field in the same record.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, June 02, 2009 6:21 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Lookup field in table

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.


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list