how do I create multiple relationships in Access

L

Lost in Meds

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!
:)
 
P

Pat Hartman

Unfortunately Access isn't omniscient. Only you know what the relationships
are so only you can define them.
 
L

Lost in Meds

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!
 
P

Pat Hartman

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.
 
Top