A
alavery7
Currently in my db I have a "master table" whose unique
identifier field is "DSR", a unique 8 digit number. Two
other tables list: 1. the components of each project and
2. the contacts for each project, both of which reference
and are tied to the DSR field.
I now need to link each of these, as well as record a 1 to
4 letter string at the juncture. For example, if this were
in spreadsheet format, it might look as follows:
For DSR 12345678:
Component Resource
---------------------------------------------------------
Andy Bob Charlie
Buy ice A R
Buy food RA C I
Prepare meal A R R
Eat dinner I RA R
My problem is, there seem to be too many variables to link
in any sort of query that would allow the DB user to enter
the RACI value. Once I add the third dataset, the query
seems to become unmodifiable. Plus, in order to have the
data stored somewhere, I need a minimum of three tables -
components, resources, and RACI entry, since the three are
independent of each other (each person can have multiple
components and different RACI entries for each, each
component can have multiple resources and different RACI
entries for each.)
Can anyone help? What am I misunderstanding?
identifier field is "DSR", a unique 8 digit number. Two
other tables list: 1. the components of each project and
2. the contacts for each project, both of which reference
and are tied to the DSR field.
I now need to link each of these, as well as record a 1 to
4 letter string at the juncture. For example, if this were
in spreadsheet format, it might look as follows:
For DSR 12345678:
Component Resource
---------------------------------------------------------
Andy Bob Charlie
Buy ice A R
Buy food RA C I
Prepare meal A R R
Eat dinner I RA R
My problem is, there seem to be too many variables to link
in any sort of query that would allow the DB user to enter
the RACI value. Once I add the third dataset, the query
seems to become unmodifiable. Plus, in order to have the
data stored somewhere, I need a minimum of three tables -
components, resources, and RACI entry, since the three are
independent of each other (each person can have multiple
components and different RACI entries for each, each
component can have multiple resources and different RACI
entries for each.)
Can anyone help? What am I misunderstanding?