Originally Posted by
Peter Simpson
I think that I have created my tables correctly however when I test it and capture dummy data the two tables DO POPULATE however when I click on the small "plus" signs there is no data relating to the records.
Somewhat confused by your narrative, but if you're trying to view Records in the underlying Table, from your Form, and they're not visible, then in Design View, with the Form itself Properties - Data and see if the Data Entry Property is marked as Yes...if so, change this to No.
Despite its name, the Data Entry Property does not have to be set to Yes in order to enter data! In this mode you can only enter New Records...you cannot view existing Records.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007