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
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mixed up with Relationships..help! | KrazyRed | New Users | 3 | January 26th, 2005 05:03 AM |
Deleting Relationships... | Kojones | General Discussion | 3 | December 17th, 2004 11:46 PM |
Relationships getting redefined? | raylitalo | General Discussion | 3 | December 15th, 2004 08:31 PM |
Establishing Relationships with ID numbers as foreign keys | lybargera | Database Design | 2 | June 16th, 2004 07:30 PM |