Supply List

[Karen Howard]

Hi,

I have two tables created.

The first has basic order information (e.g., Date of
Order, Date Ordered Needed, Date Order Sent).

The second table has that list the supplies that we use
frequently (e.g., Item #, Description, Cost)

My question is how would I setup a Table or Query that
works primarily off the First Table's information and then
I can select the items from the Second Table to place an
order.

I not sure if I need to query the Second Table or how to
link the two tables together. Please help, Thanks!

 

[John Viescas]

You need a third table to contain the items for each order. Create a form
to edit orders and a subform to edit OrderItems. In the subform, use a
combo box to lookup the Item Numbers from Supplies to set the item being
ordered in OrderItems. Take a look at the Orders form in Northwind.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)