Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Access Training and help » Relationship
Resolved · Low Priority · Version 2007
Andrew has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access Advanced course
wHEN IS THE BEST TIME TO USE 1 TO 1 RELATIONSHIPS
Hi Andrew, Thank you for the post, in answer to your question;
A one-to-one relationship exists where for every one record in the primary table there is one and only one matching record in another table i.e. a table comprising employee information and a table comprising salary information may be created because each employee has only one entry in the salaries table.
This form of relationship is used in the following scenarios:
1. Security
|
|
Access tip:Creating Parameter wildcard queriesTo creat a parameter query that also uses a wildcard, in the query design type in like []+*. |
TrustScore
4.8
/ 5
2239 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.1 secs.
