Dependent Value

[Ramtrap]

Hi all,



Is there an easy way to auto-fill tables based on one value?

For example, if I create the following tables:

CONFERENCE: {"AFC", "NFC"}

DIVISION: {"EAST","WEST","NORTH","SOUTH"}

TEAMS: {"WASHINGTON REDSKINS","NEW YORK GIANTS","DALLAS COWBOYS",...}

Is there a way I can have it set so that when I select "WASHINGTON REDSKINS" from a list, it will automatically input the correct CONFERENCE and DIVISION?

I realize I can put this all in one table, but I'm trying to understand just the concept of auto-populating a field based on the value of another. Any help is appreciated. thank you!

[pbaldy]

Here's how it can be done on a form:

BaldyWeb - Autofill

but you'd have to have them joined in some way to associate conference and division with team. That could be fields in the teams table or a new junction table.