Relationships
- Thread starter Marlena
- Start date
- Local time
- Today, 10:19
- Joined
- Jan 23, 2006
- Messages
- 15,573
Tables are for storing data. Forms and subforms are for displaying or presenting the data that are stored in tables.
Access has a Form/subform construct. It is used often when the relationship between tables is 1 to Many.
The Form gets data from the 1 Table and the subform gets data from the Many table. The link between Main and subform is made on a common field in the tables.
Typical usage:
An Author writes Many Books.
Author goes in Main form
Books go into the subform
Forms are related on LinkFields
AuthorId in MainForm and
AuthorId in subform.
Good luck.
Access has a Form/subform construct. It is used often when the relationship between tables is 1 to Many.
The Form gets data from the 1 Table and the subform gets data from the Many table. The link between Main and subform is made on a common field in the tables.
Typical usage:
An Author writes Many Books.
Author goes in Main form
Books go into the subform
Forms are related on LinkFields
AuthorId in MainForm and
AuthorId in subform.
Good luck.
Similar threads
