customers have their own product number

[Herr Li]

Dear all,

I am a new user of Access 2007.

In the samples which were given by the text books or the build-in Northwind
sample, the product number is always the same. It means when the company buy
the products from the suppliers or when they sell the products to their
customers, they use the same product number.

But the in real world, our company has our own product number for each
product, and almost all our customer has their own product number.
When placing the order to us, customer will use their own product number.

What I want to do:
In the order form, I first select the customer name or ID;
Then in the order_detail_subform, I can choose my customer's product number,
and our company's own prouduct number will appear in the next column...

Your help is really really appreicated.

Regards

Li Haibo
Guangzhou, China

 

[John W. Vinson]

Answered in microsoft.public.access and (by another volunteer) in
microsoft.public.access.gettingstarted.

Please don't multipost the same question to more than one newsgroup. We're all
volunteers donating our time here; it's annoying to put effort into answering
a question in one group only to find that a colleague has already done so in a
different group.

John W. Vinson [MVP]