one to many relationship tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If anyone out there can help, I would really appreciate
it.

I have three table.

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.
 
Have you looked at form / Subforms. You link the two
forms together using the Link Child & Link Master
property fields.

Hope this Helps!

Dean
 
Back
Top