All,

While not precisely a newb, it has been a long, long time since I've done Access 2003 work and that's all they have in my new job (yay). I used to know how to do this, but first the structure:


Table_A
Key
Subject
Date
etc.

Table_B
Key
Boy y/n
Girl y/n
Alien y/n

Table_Boys
Key
<stuff about boy>

Table_Girls
Key
<stuff about girl>

Table_Alien
Key
<stuff about alien>

What I want to do is populate A and B then only populate Boys, Girls and Alien if the block in Table_B is "Y" for the respective y/n fields. Although I could do this in one big table, it would be far cleaner to do it with the separate tables I've shown. I'm almost certain I've done this before but can't remember how...please give my brain a nudge!

Thanks in advance,

S

Solved it! It's all in the Forms, folks (the logic about which table to populate when, I mean.) I also discovered that they would let me use 2007 if I asked...not great but not nothing, either.