Automatically finding a corresponding number based on selected number

[SHAWTY721]

I have a table that contains 900+ records that are related to each other on a row basis. The Dept field needs to be able to determine which of the other account numbers is being used.

-Once a particular department is selected I need to have the corresponding numbers fill a form based on the department that is being used.

- The other aspects of the form will be imported from an external source that my company is using to do gather the payroll information.

- I thought of creating an IF Statement that would check to see which Dept is being used and based on that fill in the other Account Numbers. I guess where I ran into problems with this approach was trying to make the IF Statement generic so that I could use one IF Statement for the whole table instead of writing multiple statements since there are so many records for this particular table.

 

[SkipVought]

Hi,

Use a query of Accounts quallified by selected dept.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}