I guess I should have been clearer in my last posting.

I have a field named "OCC Title" this contains the job position titles.

"OCC Title" is a drop-down list, with values from a record that I imported from excel.

I have another field named "OCC Code", this is the field for Occupational Codes.

Then I have these fields called "States", "Average Salary", "Entry Salary", and "Maximum Salary".

What I wish to happen is this:

1) I wish to see the "OCC Codes" automatically filled every time a value within the drop-down field "OCC Title" is selected.

2) I wish to see the fields "Average Salary", "Entry Salary", and "Maximum Salary" automatically filled per "State", whenever a value from the "OCC Title" is selected.

I truly will appreciate any help I'd be able to get.

Thank you in advance.

Elena

Edited November 28, 200817 yr by Guest

"OCC Title" is a drop-down list, with values from a record that I imported from excel.

Do you mean a list in the value list or a field choice in the VL from a separate table for OCCTitle?

You should have a separate table related to your main table. Within that OCCTitle Table you would have all your fields:

fk_MainTableID

OCCTitleID

OCCTitle

OCC Code

States",

Average Salary

Entry Salary

Maximum Salary

Then when you chose the title the other fields will also populate with the correct data.

See attached

VL_Test.zip

Hi there, thank you so much for the help.

Elena