Parent Child Relationships Help Please!

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.

On Mon, 7 Jun 2004 06:41:02 -0700, "Heather"
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public