I have a table that has to give the exposure limits of a parent item. The child items determine the exposure limits based upon another table.
So it works like this
Parent item no. has a exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 2
Child item no3: exposure code 3
Child item no4: exposure code 4
It could also work like these examples
Parent item no has exposure code 1234
Child item no1: exposure code 14
Child item no2: exposure code 23
or
Parent item no has exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 23
Child item no3: exposure code 1
Child item no4: exposure code 2
Child item no5: exposure code 4
Each exposure number represents a differnt exposure for example
1=Light
2=Heat
3=Moisture
4=Cold
The child items combined make the parent exposure code.
So I have 3 tables: FMMAST (Parent) FMITEM (Child) INMOEL(exposure code)
FMMAST - Table
Parent Item No. - Field
Combined Exposure Limit - Field
FMItem - Table
Parent Item No. - Field
Child Item No. - Field
INMOEL - Table
Child Item No. - Field
Exposure Limit - Field
What is the best way to combine the child exposure codes into a field in the Parent Table.
Thanks in advance
So it works like this
Parent item no. has a exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 2
Child item no3: exposure code 3
Child item no4: exposure code 4
It could also work like these examples
Parent item no has exposure code 1234
Child item no1: exposure code 14
Child item no2: exposure code 23
or
Parent item no has exposure code 1234
Child item no1: exposure code 1
Child item no2: exposure code 23
Child item no3: exposure code 1
Child item no4: exposure code 2
Child item no5: exposure code 4
Each exposure number represents a differnt exposure for example
1=Light
2=Heat
3=Moisture
4=Cold
The child items combined make the parent exposure code.
So I have 3 tables: FMMAST (Parent) FMITEM (Child) INMOEL(exposure code)
FMMAST - Table
Parent Item No. - Field
Combined Exposure Limit - Field
FMItem - Table
Parent Item No. - Field
Child Item No. - Field
INMOEL - Table
Child Item No. - Field
Exposure Limit - Field
What is the best way to combine the child exposure codes into a field in the Parent Table.
Thanks in advance