I think Relationships

P

Pakua

Hello,

I am very new to Access and I am trying to perform the following...

I have the following tables, ENVNames and ENVInfo. Basically, on my form, I
want to select the name of a specific environment and then have all the
fields, from my ENVInfo table, display appropriately. Right now nothing
displays when I select the Environment Name.

Lost.
 
J

John Vinson

Hello,

I am very new to Access and I am trying to perform the following...

I have the following tables, ENVNames and ENVInfo. Basically, on my form, I
want to select the name of a specific environment and then have all the
fields, from my ENVInfo table, display appropriately. Right now nothing
displays when I select the Environment Name.
Click to expand...

How are you "selecting" the Environment Name?

Normally this would be set up using a Form based on ENVNames and a
Subform based on ENVInfo, using the Primary Key of ENVNames as the
"master link field" and the corresponding related field (the "foreign
key") of ENVInfo as the "child link field".

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top