Parent Child Relationships

[tbride00]

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.

 

[Roger Carlson]

On my website, see sig below, is a small sample database called:
ImplementingM2MRelationship.mdb which illustrates 2 ways to do this,
depending on what you are trying to accomplish.