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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Recommended Table Structure for Facilities Database
lameid, I will probably try grouping the fields (each group of capabilities gets its own table). At my skill level at this point, that will definitely be the fastest way to getting a database done and ready for use. dhookom and MajP, The At Your Survey database has given me some ideas, and...- anymouse
- Post #8
- Forum: Microsoft: Access Tables and Relationships
-
Recommended Table Structure for Facilities Database
Thank you for your responses. I will keep reading about data normalization. The names and numbers were simplified for clarity. Capability_001 could actually be AvgCyclesPerDay. Capability_002 could be MaxLoad. Capability_003 could be RPXCapacity. Capability_004 could be StagingMethod. And...- anymouse
- Post #4
- Forum: Microsoft: Access Tables and Relationships
-
Recommended Table Structure for Facilities Database
I am creating a MS Access 2003 database to manage information about 300 facilities. Each facility has 500 capabilities associated with it. For example, FACILITY_001 might have: CAPABILITY_001=Y CAPABILITY_002=72 CAPABILITY_003=Steady State And so on... Additionally, each capability...- anymouse
- Thread
- Replies: 9
- Forum: Microsoft: Access Tables and Relationships
-
Can you link to a specific sheet within an XLS workbook stored on LL?
Is it possible to link to a specific worksheet of an Excel workbook that is stored on a Livelink server? For an Excel workbook stored on a Windows file system, you can create a hyperlink to a specific worksheet within that workbook by using a link such as: file://C:/Workbook.xls#Sheet3!A1. If...- anymouse
- Thread
- Replies: 2
- Forum: Open Text: Livelink
