-
Sub Form
I am trying to create a form and sub form in a database. I have created a one to many relationship between two tables. Both tables have exactly the same field properties to the field that is related.
As per the instructions in the On Line Help for creating a subform, I click on the Form Wizard and select tables/queries and select the fields from each of the two tables. According to the instructions, when I have finished selecting fields and press next, I should then see a page which asks "How do you want to view your data", but does not include the Form with subform(s) button and Linked forms button, just a tabular type datasheet.
This is a simple CD database with the main form showing the CD No. and title, and the subform should show the tracks for that CD, but I cannot get it to work.
Any ideas, I would really appreciate help.
-
The subform should only be related to the one table. The main form contains the parent table fields and the subform contains the child table fields and they are linked by the common key.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules