Dual lookup and replacement

[caman]

Hello.

I need help with a small problem.

Among a lot of fields, I have the field "cust_nr" and the field "cust_name". They are both located in the Table "TrspReg".

I have set both "cust_nr" and "cust_name" to work in a drop-down list.

Now, here is my problem.

I want to be able to i.e. enter the customer id number in the field "cust_nr", and then the customer name shows in "cust_name" (this I have mede work), But I also would be able to enter the customer name instead of the customer number. I.e. I enter the customer name in "cust_name" and the customer number shows in "cust_nr".

That I cant meke work...

I need to make each field be replaces by the last input from the other field...

Can anyone help?..

Thanx!

caman

[victorialine]

Can you post the database so that we can see what you have done and how you have it set up?

Thanks,

Vic