customers have their own product number

Tech-Archive recommends: Speed Up your PC by fixing your registry

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...

Can anyone tell me how to create table and link tables to have this effect?

Your help is really really appreicated.

Regards

Li Haibo
Guangzhou, China



.

Relevant Pages

  • RE: Selecting column entries based on data matching
    ... When I select a Contact from the drop down list on my order form, ... have attached code to the contact name control on the form to do this and it ... For example, if there is a phone number stored in the customer table, you ... Set the ControlSource property of the control to this: ...
    (microsoft.public.access.modulesdaovba)
  • RE: product date stamp file save
    ... reference to only saving an individual order form rather than all 3 in one go. ... "Robert Loxley" wrote: ... You can change the A1 to the proper cell. ... the user will be prompted for the customer name. ...
    (microsoft.public.excel.misc)
  • RE: product date stamp file save
    ... You can change the A1 to the proper cell. ... "Robert Loxley" wrote: ... the user will be prompted for the customer name. ... specific cell in an order form. ...
    (microsoft.public.excel.misc)
  • RE: product date stamp file save
    ... the user will be prompted for the customer name. ... specific cell in an order form. ... I have 3 order forms set out vertically on a single spreadsheet covering 1 ...
    (microsoft.public.excel.misc)
  • customers have their own product number
    ... In the samples which were given by the text books or the build-in Northwind ... When placing the order to us, customer will use their own product number. ... In the order form, I first select the customer name or ID; ...
    (microsoft.public.access.forms)