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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Best structure for lots of yes/no's?
Hello, Currently working on a database for a "somewhat standard" product with lots of options customers can purchase. Options are almost all "yes/no" type, with a smattering of "if yes, how many" type scenarios. Database uses the product serial number as the primary key. So, is the best way...- Griphus
- Thread
- Replies: 14
- Forum: Microsoft: Access Tables and Relationships
-
Lookup Table "Best Practices"
Hi! A coworker and I are having a debate about the most correct way to do something. I'll attempt to describe this as objectively as possible. :-) We have a database with several lookup tables. This is for building motors, so the tables are for things like bearings, the enclosure for the...- Griphus
- Thread
- Replies: 9
- Forum: Microsoft: Access Tables and Relationships
-
Any way to use logic & procedural decisions in database design?
Hello and thanks for any help. I am trying to build / fix a database of projects for a manufacturing company. Each project is for one or more parts with model numbers. Those model numbers are set up such that the acceptable characters later in the number are based on the choices earlier in...- Griphus
- Thread
- Replies: 16
- Forum: Microsoft: Access Tables and Relationships
-
MS Project -> Excel Tasks to columns
Hi everyone, Summary: I am looking for an efficient way to display quasi-standard tasks for multiple (~60) projects that we are tracking in MS project as columns in Excel. Because the tasks are quasi standard, we give each task a column, each project a row, and create a matrix of finish dates...- Griphus
- Thread
- Replies: 6
- Forum: Microsoft: Project
