January 1, 200917 yr 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.
January 1, 200917 yr 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.
Create an account or sign in to comment