Parent Child Relationships Help Please!

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

Would someone out there be able to help me with Parent
Child Relationships?

I have two tables that I would like to manually create
joins. The tables are as follows:

Table 1 consists of input data (1)
ProblemID p(k)

Table 2 is the join table (M)
ProblemID p(k)
QuestionID p(k)

Table 3 consists of input table (1)
QuestionID p(k)

I would like to create a form that allows me to attach
dependancies data Table 1 and Table 2 and essentially
make a join for the two values. Does and easy way to do
this exist?

Thanks in advance for your insight.
 
Would someone out there be able to help me with Parent
Child Relationships?
...
I would like to create a form that allows me to attach
dependancies data Table 1 and Table 2 and essentially
make a join for the two values. Does and easy way to do
this exist?
Click to expand...

The simplest way is to create a Form based on one of the "one" side
tables - I'd say Table1 in your case if the list of questions in
Table2 is pretty much static. On this Form put a Subform based on
table3, using the linking field as the Master/Child Linking Field
property. On the subform put a combo box based on Table3 to insert the
questionID.
 
Back
Top