I think Relationships

[Guest]

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.

 

[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.

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