Search results for query: *

Thanks lupins46! I appreciate your help. The only problem I'm running into is that I need all 50 or so tables to relate to one main table of subject information. Since Access's limit is 32 (including the indexes!), I have nearly 20 tables that still need to be related. Now, in my second...

I met w/ my db instructor yesterday, and she suggested making 2 separate databases and linking all the other tables in the 2nd db to the main table in the 1st db. The only problem is that it still won't let me enforce RI in the 2nd table. Is there any other solution? I need to keep RI...

So, I don't absolutely have to have the enforced RI. Great! I'll keep the most important 32 tables linked, and the rest will just be floating. According to a database instructor at our research instiution, it is better design for our study to have each test in a separate table. Thanks so...

Unfortunately, I do not know how to show you an example of my table, but maybe this will clarify. For example, my demographics table contains an ID No (my primary key), and demographic info for all my subjects (thousands!!). Inside the relationships section of the database (where you drag &...

I am relatively new to Access, and have made an extensive database for research statistics. I am basing all 36 tables off of one main table containing each subjects' demographics. My problem in creating relationships is that tables 1-31 have linked appropriately to the demographics table, BUT...