Order details subform

D

Dee

I have a form that I enter information regarding orders.
There is a main form with the customer information and a
subform with info regarding the order details .Each
customer has a different price list. What would be the
best way to link the customer number to the price list for
that customer and have another form open with the customer
price list. Then I would like to be able to choose the
price for the product and have that entered into the price
for that customer on my subform. Maybe there is a more
efficient way of doing this. I am using Access 2000.

Any help would be greatly appeciated.

Regards,

Dee
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Copy previous record into form field 0
Office 365 Email Encryption One time Passcode 0
Drop down lists in seperate columns 5
Mailmerge - page breaking to new customer 1
MS Project Import Error Row 1 Column 5 2

Top