multilevel conditional lists

[mathac]

Hi,

I have: two tables, A the data file containing the records & B the options file.

On Table B

1. drop down list-Companies

2. 2nd drop down with the items.

The second list depends on the company chosen from first list. This works fine.

I need to then have the cost of the particular item chosen automatically appear in the field for "Cost".

Does anyone know how to describe how to do this?

M

[bcooney]

I would have a Cost field in Table B lookup the Cost of the Item using a relationship to Items by ItemID.

Be sure to relate your records using IDs not text values. For example, you say that in "TableB" you have a drop down list of Companies. That doesn't sound very good, because it suggests that you are storing a company name rather than a companyID in TableB.

[mathac]

Thanks so much. It sounds very simple. I will give it a try

M