Parent Child Relationships Help Please!

[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.

 

[John Vinson]

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?

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.