Help - establishing Relationships!!!

I have a product list!!
Based on that list I am building customer requirements, by product, schedule
date and quantity.

The list is huge and I don't have to deliver the items all at once.

What king of relationship I need to set up in order to keep track of the
orders I am sending, periodically, and track confirmation of receipt?

Thanks in Advance,
Peter

With the extent of the information you have provided and the potential
expanse of requirements, I would suggest hiring a good contract programmer.

--
Duane Hookom
MS Access MVP


"Peter" wrote in message
...
I have a product list!!
Based on that list I am building customer requirements, by product,
schedule date and quantity.

The list is huge and I don't have to deliver the items all at once.

What king of relationship I need to set up in order to keep track of the
orders I am sending, periodically, and track confirmation of receipt?

Thanks in Advance,
Peter

On Tue, 15 Mar 2005 22:00:27 -0500, "Peter"
wrote:

I have a product list!!
Based on that list I am building customer requirements, by product, schedule
date and quantity.

The list is huge and I don't have to deliver the items all at once.

What king of relationship I need to set up in order to keep track of the
orders I am sending, periodically, and track confirmation of receipt?

Thanks in Advance,
Peter


Insufficient information - and as Duane suggests, probably an overly
large project for a newsgroup message to design.

I can't even tell for sure what entities you have. Customers,
Products, Requirements (whatever they are), Deliveries, Orders,
Confirmations for sure, but probably others as well; each of these
will (I presume) get its own table. How the tables are related will
depend on your business needs and what you want the database to do.

Post back with some more details about just what you want to
accomplish - or as suggested, hire an expert.

John W. Vinson[MVP]