next step?

  • Thread starter Thread starter rvmom
  • Start date Start date
R

rvmom

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!
 
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!
Click to expand...

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
 
Back
Top