how do I create multiple relationships in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey
I am creating a new database to use with Dr's and Staff to help with
recording labs and all their data. I have made about 26 tables for the
database and now I need to link them. Is there a faster way of est.
relationships between the tables or am I going to have to work on this for a
long time, piece by piece?
I apprechiate any and all Help!

Thanks!
:)
 
Unfortunately Access isn't omniscient. Only you know what the relationships
are so only you can define them.
 
Yes I know this, but what I am looking for is a way of spending up the
process. Instead of est one field at a time or one table at a time. Instead
of taking each of the 26 tables and linking all 56 pieces of data in each one
one click by one click.
I dont want the program to be omniscient, just want it to be faster so this
project set up doesnt take 6 years to complete.
But thanks for your help!
 
Your other alternative is with code. You can use DAOto modify the tabledefs
collection or you can write DDL queries to create the constraints. I doubt
that either would be faster than using the GUI.
 
Back
Top