conditional look-up table

[Guest]

I have a invoice tracking database I have created with multiple look-up
fields referencing other tables. The challenge I am having is creating a
field that will lookup in a particular table based on what has been entered
in a field within the original main table. For example:

If the user enters they work in department Front Desk, I want the Account
Names Field to look at the General Ledger Account Names table specific to the
company associated with the Front Desk. If they choose a different
department that is associated with a different company, I want the Account
Names field to have a drop down box referencing the General Ledger Account
Names table specific to this other company.

In total I have three different companies, each with their own separate
account names, with their own account general ledger codes.

If anyone could assist, it would be greatly appreciated.

 

[Rick Brandt]

I have a invoice tracking database I have created with multiple
look-up fields referencing other tables. The challenge I am having
is creating a field that will lookup in a particular table based on
what has been entered in a field within the original main table. For
example:

If the user enters they work in department Front Desk, I want the
Account Names Field to look at the General Ledger Account Names table
specific to the company associated with the Front Desk. If they
choose a different department that is associated with a different
company, I want the Account Names field to have a drop down box
referencing the General Ledger Account Names table specific to this
other company.

In total I have three different companies, each with their own
separate account names, with their own account general ledger codes.

If anyone could assist, it would be greatly appreciated.

Don't use lookup fields and DON'T work directly with tables. If you use
ComboBoxes on a form this is simple. It cannot be done with a table.