Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database Design for Multiple Dates
This makes perfect sense. Thanks. But I am having trouble constucting this table. Would I create a BackorderDetails table, that is linked to the OrderDetails table through a BackorderID field? The OrderDetails table dos not have its own Order DetailsID as set up in Northwind, so I am a bit...- dinovitz
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Database Design for Multiple Dates
Thanks so much for your reply! I will have multiple dates, so would all dates go into this additional table, or only "backorder" dates? What would then be captured in the order details table? And just so I understand, what is the logic for creating this additional table? Thanks again...- dinovitz
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Database Design for Multiple Dates
Hi, I am new to MS Access 2000, and am designing a database for which the Northwind database provides a good model. The twist in my design is that the products associated with each order will have their own ship dates, expected ship date, and status (eg. not shipped) etc. So instead of the ship...- dinovitz
- Thread
- Replies: 6
- Forum: Microsoft: Access Tables and Relationships
