98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Table Relationships
Table Relationships
Resolved · Low Priority · Version 2007
Fri 25 Jul 2008, 16:17Delegate David said...
David has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course
Table Relationships
Best way to describe one-to-many table relationships
Mon 28 Jul 2008, 13:06Trainer Carlos said...
RE: Table Relationships
Hi David
One way to describe a One-to-Many relationship is:
A Student has only one Maths teacher in any one year.
However the Teacher will have many students
This is the One-to-Many relationship.
In the relationship window the line would go from the Teachers Primary Key(The One) on the Teachers Table to the Teacers Code field(The Many) on the CoursesTaken table
Hope this helps
Carlos
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Zoom feature for queriesIf youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field |
