Greetings all...


I have been working on my tables..normalising, blah, blah..and I have a posing question regarding my form(s)

Some of my tbls are joined via Foreign Key and in the parent table they are only the ID(FK)

How does this work with showing the record...Can someone please set me down the right path so I can understand what it is I am actually doing?

Example:

main table has an ID for State

How is this going to work on my form

Probably a stupid question...but crawling comes before walking (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

VR

DWilliams

Hi,

Check the attached sample:

tblMain uses tblStates as a lookup table
tblMain and tblComments have a 1:M relationship (one Main record can have many comments)

Open frmMain:

cbofkStates uses the lookup tables as the source
the comments for each main records are in the subform

I left the PK and FK so that you can see the values in the form, usually users are not exposed to them.

HTH

Thanks Doug

I am using this to set my mind straight...understanding how things work together might help me

VR

DWilliams

No problem...
Glad to help (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Hope the sample helps you understand how things work together...

LMK if questions.