If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
next step?
I have created 3 tables:
Customers w/ id, name, address, etc. fields Items w/ id, descriptn, price, category fields Category w/ id, categ. name Now I need to enter each customer's order and I'm at a loss as to how is the best way to approach this. I've been doing a lot of reading and I think that has confused me!! My end result will be a report totally different things. I think I know how to do that part okay, I just need help on doing a form, query, table (?which one) to enter order info. Also, my copy of Office 97 Prof., did not include the Northwinds sample database. Does anyone know where I can download it? Thanks in advance! |
#2
|
|||
|
|||
next step?
Also, my copy of Office 97 Prof., did not include the
Northwinds sample database. Does anyone know where I can download it? Thanks in advance! I believe you can find it under Help/Sample Databases. The general strategy used is a main form based on a query that links your Customer and Orders tables by Customer #. That way, once you've entered the customer number for the order, any Customer fields you wish to display, such as the name, address, etc. will show. You may wish to use a combo box for the customer number. Onto the main form, insert a continuous subform based on the Order Details table. Set the LinkMasterFields and LinkChildFields properties of the subform to the OrderNumber field of the Orders and OrderDetails tables, respectively. Good luck. HTH Kevin Sprinkel |
Thread Tools | |
Display Modes | |
|
|