Hi there,
Please forgive me if I'm posting in the wrong place but not only am I new to Access but also new to forums.
So... I'm currently working as a welding & fabrication inspector / quality manager for a company in South Africa but while working I've been studying and have completed the theoretical portion of my education that will enable me to become AIA / 3rd party inspector. However, there is a practical component to the certification. This involves execution of 18 task on 5 pressure vessels / boilers and or high pressure piping systems all in the presence of an already certified inspector. I'm also required to keep documented proof of all 90 tasks (18 tasks x 5 equipment). Thus in a moment of infinite wisdom I decided to compile a database to help me keep track of my progress and eventually present my recordkeeping in a professional manner to the panel of experts appointed by the South African Institute of Welding.
Initially, I envisage my database consisting of 6 tables:
Please can any of the wise folks assist, my big problem is the correct setup of the database and then Table 5.
Thanking you all in advance,
DeVos
Please forgive me if I'm posting in the wrong place but not only am I new to Access but also new to forums.
So... I'm currently working as a welding & fabrication inspector / quality manager for a company in South Africa but while working I've been studying and have completed the theoretical portion of my education that will enable me to become AIA / 3rd party inspector. However, there is a practical component to the certification. This involves execution of 18 task on 5 pressure vessels / boilers and or high pressure piping systems all in the presence of an already certified inspector. I'm also required to keep documented proof of all 90 tasks (18 tasks x 5 equipment). Thus in a moment of infinite wisdom I decided to compile a database to help me keep track of my progress and eventually present my recordkeeping in a professional manner to the panel of experts appointed by the South African Institute of Welding.
Initially, I envisage my database consisting of 6 tables:
- tbl_Task List - This will just be a table with 18 tasks and will have and ID field, Task Description Field & a Min Requirements Field
- tbl_Vessels - Here I will store all the pertinent information about each individual pressure vessel inspected, ID, Serial #, Description, etc...
- tbl_Boilers - Here I will store all the pertinent information about each individual Boiler / Steam Generator inspected, ID, Serial #, Description, etc...
- tbl_Piping - Here I will store all the pertinent information about each individual piping system inspected, ID, Serial #, Description, etc...
- tbl_Tasks Records - Here each task will be captured.
- tbl_IPE - Which will be like a contacts table with the information of the certified inspectors that accompany me on the inspection.
- ID
- Task - cboBox getting the information from Table 1
- Equipment type - Value List with 3 options Vessel, Boiler or Piping System
- Equipment Inspected - I'd like this to be a cboBox that gets its data from either one of the 3 tables (tbl_Vessels, tbl_Boilers or tbl_Pyping System) which is dependant on the selection made in the previous field (3).
- Inspector - cboBox listing the qualified inspector
- Project - details of the project on which the inspection was done &
- Attachement - Here I would like to save all the scanned paperwork / proof of the particular inspection.
Please can any of the wise folks assist, my big problem is the correct setup of the database and then Table 5.
Thanking you all in advance,
DeVos