0

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

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by ShadesOfGrey
0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.