Automatically fill in combo boxes

[matpj]

Right, heres the thing:

I'm using Acess 2000. I dont know anything about code and events etc - so someone will have to hold my hand through this one!

I have two tables I have linked from an Oracle Database.
I have created a query which looks up the customer name form one of the Oracle tables and the relevant Stand number from the other Oracle table based on a common 'account number' field.

So now I have one query which shows all the information I need.

On my form I have two combo-boxes, one which looks up the Stand Number from Oracle, and one which looks up the customer number from Oracle.
I need the user to select one of the stand numbers from the combo-box and would like Access to automatically fill in the customer that is assigned to that stand. Also vice-versa, if the customer is selected, the stand number is filled in.

I replaced the combo boxes on the form (originally using the table fields) with new combo boxes using the query fields.

what do I do to make the system automatically fill in the boxes?!!
this has been driving me mad!

I would appreciate any help you could offer,
regards,
Matthew

 

[Garridon]

This site has some information that may be able to help you (I'm not sure on the Oracle end, but certainly, it'll give you something to work with).

http://www.mvps.org/access/

Linda Adams (Garridon@aol.com)
"The Importance of Being Grammarian," published in The Toastmaster, March 2001

http://www.geocities.com/hallona_2000

http://www.david-hedison.com