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:
<stuff about boy>
<stuff about girl>
<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,