Recent content by NicoleGW

How do users indicate which tests they've done for a panel? Do you have a table with one field for each possible test, and then one record per panel stored in that table? Or does the user enter a separate record for each test? Basically, in your table where you actually store info about what...

Sounds good! I will go ahead and give it a try. Coincidentally, I just got a new shell from the original designer, in which she fixed little bits of code here and there to make sure it's fully compatible for MS 2003 users, so maybe that will help. Thanks so much!

Ah, I see, that makes sense. I'm definitely going to split the database, I just am worried that there's some other issue going on, and if I don't track it down we're not going to be able to trust our records in the future. The problem is that no one is deleting these records that are causing...

Sorry, this is going to sound stupid, but when you say remove cascade delete constraints do you mean that I WANT to have cascade deletions, or that I DON'T want cascade deletions? I'm really careful about setting up relationships, and haven't changed any in the past few weeks. Thanks for the...

There've been a few threads about similar issues in the past, but I couldn't find anything that would solve the problem I'm having at the moment. I manage a big complex Access database for my lab. I didn't design it, but I add forms and tables as they're needed. It's always been perfectly...

Okay, I think I have it figured out. I used SQL view to create a bunch of nested queries running in the background, and it looks to the user like there's just one query that pulls all the data into one table. I'm still getting a few repeat rows, but that's just because certain tables had more...

Sorry it took me a few days to respond. Really busy at work. jzwp22, thanks so much for taking the time to type out that structure. I've played around with it, and it's really neat to reconceptualize the database like that. Unfortunately, the database I'm working with was already in use...

Unfortunately, the different tests produce different data, so they can't all be consolidated into matching fields or one table. Here's a simple two test example: Test A 1. Participant Code 2. Date of Test 3. Do you like red? (Y/N) 4. Do you like green? (Y/N) 5. Do you like yellow? (Y/N) Test...

Hi everyone. Apologies if this has come up before, but the search terms I've tried here and on google keep turning up the wrong information. At work I manage a large database with many tables. It stores data for participants in a research study. Each table stores the data for a different...