what's the best way to do this?

[clueless2003]

Hello again...

I'm still working on the database in which the users input the account number in the combo box field and get all of the other information instantly....only things have changed slightly.

Now, it's come to my attention that within each Account # there are several Sub-accounts, which may have more than one Sub-ledger associated with it.

So, the earlier simplicity of my database has gone by the wayside, apparently.

Now, my question is "How do I do this? "

 

[mark curtis]

the combo returns detail for the main account. there must be a link id between main account and sub accounts. So create another form with the sub account details on and then use that form as a sub form to the main account form and requery on change of the combo.

 

[clueless2003]

Sounds good, but I'll pass this by the group one last time (with more detail) to see if anybody else has thoughts to share.

The main fields:
Account #
Account description
Subaccount #
Subaccount description
Subledger account #
Country code
Location code
(there are several others....I'll save bandwidth and not list them all here!)

The objective:
The user will be able to input the account # in a combo-box, which will output several related fields (i.e., country code, location code, etc). Upon entering the account #, the user will also have a choice of several subaccount numbers (the descriptions will also be available). For some subacccounts, but not all, there will be one or more subledger accounts from which the user will pick one (if available). Now that all of this data is input, another set of data should populate based on these results (specifically, the account #, subaccount #, and subledger #).

So, I think Mark is on the right track, but I just wanted to put the entire situation before the Access Users round table before I proceed.

Thanks in advance!