welcome to the forum, thanks for the post.
I've written 'bout this a bit over the last couple of days. With your kind permission, please let me forward you to where I already typed this out. If you have further questions, please post again after you've tried it out. The concepts you'll need are listed in the link below. Be glad to help additionally as needed...
Please let us know how you're coming along...
Thank you for the prompt reply. I have set the db up just as you suggested with the book example. Still it is not populating? I must be missing something simple?
you have two tables that are related...lets call the tables 1&2
Check#1: make a layout based on table1 that has the linking fields from both tables 1&2. One of the fields should start with "::" when viewed in layout mode, the other shouldn't.
go through your records (perhaps try list view) and make sure that the contents of the fields match each other. If they don't, then this is the reason you're having problems. No match = no link = no related record to pull data from.
The field you enter info into should be from the same table as the layout is based on. (not really mandatory, but lets use it for now) The fields you expect to populate automatically should be from the linked table and should all start with :: in layout mode.
How do you do with these two checks?
So I now understand that I did not have it set up correctly in the Layout. Corrected that but it is still not working. :smileysad: *sigh*
When it works, there will be an "a ha" moment. In order for me to help you with it, you have to describe what's going on...
What have you done, what have you tried, what are the results...ya gotta give me somethin' to work with...
The forum is here to help you work things through.
Is there a way for me to upload or (email) you the file? Or at least a PDF of the Relationship map?