Auto fill a field from multiple lookup

[shahemaan]

hi,
I am new in to Ms Access and need help on following matter



i have three tables in my database.

[customer]=> CID, Cname, Ccontact, SupplierID
[Supplier]=> SupplierId, Suppliername, Suppliercontact
[ order]=. OrderID, CID, SupplierId, product.

i have a multiple lookup field of CID|SupplierID from [tblCustomer][tblSupplier].

i am working on order form and i want if i put CID from lookup it automatically fill Supplier ID associated with that customer or any other way to fill SupplierId auto instead of look up field.
Awaiting for early reply please
Thanking you in anticipation

[eronchengwa]

Are you done with this?

[dkanti]

still not solved???

[Missinglinq]

If you have a similar question you'd do well to start a new thread, rather than resurrecting a thread that is almost 5 years old. The OP from this thread has not posted, here, in that time, and is not very likely interested in an answer at this late date.

Linq ;0)>

[June7]

Especially since the original question makes little sense.