Automatic filling of forms

  • Thread starter Thread starter Yuga MOchtar
  • Start date Start date
Y

Yuga MOchtar

Dear Colleagues,
I have experienced a problem when i designed a form . Just
say..a customer order form that automatically fills the
line of product description and supplier price after i
insert the product code from the combo box. The product
code, product description and supplier price is generated
from other table, which has its own primary key.
Please assisst me in resolving this problem.
Thank you
Sincerely,
Yuga
 
Yuga MOchtar said:
Dear Colleagues,
I have experienced a problem when i designed a form . Just
say..a customer order form that automatically fills the
line of product description and supplier price after i
insert the product code from the combo box. The product
code, product description and supplier price is generated
from other table, which has its own primary key.
Please assisst me in resolving this problem.
Thank you
Sincerely,
Yuga
Click to expand...

If the description and price don't change over the time the invoice will be
of value to you then this would be done with a query that relates your
detail table to the inventory table.
Your Detail would only have to contain The Invoice ID, the Item ID, the
quantity, and possibly a discount code or something.

If you need to keep a history of the detail then usually I would add a
description field and a price field to the detail table.

The afterUpdate event for the ItemID would be something like
Me!DetailDescription = Me!InventoryDescription and Me!Price =
Me!InventoryPrice

I must admit that I sometimes add the CustomerID and a couple other things
to the detail table.
It's left over from the days of slow machines and slower databases.
 
Back
Top