Popup list in popup list

[milky]

Hi all,

Hope everyone had a great new year.

I am trying to do the following:

user selects an item from a pop up list.

Once this is done then the user is asked to select from a popup list for items only connected to the first choice.

The tables are:

1st Table: Account type:, PK AccountTypeID, only other field AccountTypeName.

2nd Table: Account::, PK AccountID, AccountName, AccountNumber, Balance, BalanceDate, TaxType.

Do I have to add fields into both tables so they can be used as lookups? and what should I link the two tables by?

Thanks again.

Milton.

[bcooney]

You need what's referred to as a conditional value list. It's not clear to me what limits the choices in the second popup menu.