Created 3 trial tables. Linked and populated the tables. Data not showing in pull down menu.
relationships.pdf
PopulatedTables.pdf
DogTrial2.pdf
accessTrial.pdf
Created 3 trial tables. Linked and populated the tables. Data not showing in pull down menu.
relationships.pdf
PopulatedTables.pdf
DogTrial2.pdf
accessTrial.pdf
the link may exist, but you haven't populated the OwnerID_FK field
Thank you -- I just populated that and now it works, but I guess where I started having trouble is I don't understand how I can populate that field without having to go back and manually open the other table that gives me that info. Is this the place where a lookup wizard can be applied?
tables are not intended for direct input of data - for that you use forms
Note the rule for forms is one form, one table
This demonstrates how it can be done
1.create a main form with tbldogowners as its recordsource (this should be a single form)
2. create another for tbldogs - would expect this to be a continuous form since one owner can have more than one dog
3. go back to your dogowners form and insert a subform - you will be prompted for the name of the form (select dogs form) and to identify the linking fields (OwnerID and OwnerID_FK)
job done. If you use the wizards it will take about 30 seconds - you can play with the layout once everything is working
but it may not be how you actually want it - to do that, you need to describe your processes that result in you completing a record
e.g. enter owner, then enter their dogs, then enter their licence
or to update a licence - you do what? or add a new dog? what happens if an owner doesn't have license details to hand? etc
Thank you for your assistance. I appreciate your help.