Access 2007 relationships

Access 2007 setting up relationships between tables

9 Responses

fielmaso Says:
March 7th, 2010 at 12:53 pm
file maker!!!
3363085 Says:
March 7th, 2010 at 1:22 pm
how to creat a one-to-many relationship ??
imtiazmuhsin Says:
March 7th, 2010 at 2:13 pm
Thanks! that was pretty useful
elizbethqtyetye Says:
March 7th, 2010 at 3:05 pm
Nice work. keep it up. mean time come for social media marketing for esteembpo**com HFFD
OfficeSavant Says:
March 7th, 2010 at 3:09 pm
Good job, however when enforcing Referential Integrity — RI (alone) data changed in one table does not change (related) data in another. This is actually a feature of RI. By enforcing RI we have the ability to Cascade Updates (and deletes). Enforcing RI alone actually prohibits orphaned records.
OfficeSavant Says:
March 7th, 2010 at 3:24 pm
An intermediate relationship type occurs when neither field in the related tables is a primary key. (Primary key is a unique identifier for any record in the database).
scorptile1 Says:
March 7th, 2010 at 3:57 pm
i have a question we wanna know how do we find out what our problem is when doing a relationship when it says indeterminate instead of one of many?
TheRoof66 Says:
March 7th, 2010 at 4:51 pm
The Access basic lessons are not sequenced so I can get lost in the information… However they’re very helpful. Could you maybe give numbers to lessons? It would ease things to clearly follow the set up of a first database for a beginner…
Shirina1976 Says:
March 7th, 2010 at 5:48 pm
It was very helpful to finish my class assignment.Thank you!