troubleshoot form

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have a form based on two tables
Patient demographics table -primary key is Case No
Patient results table - primary key is Laboratory Number

I have used a junction box with both Case No and laboratory Number as
primary keys to create 1-many relationships b/w each table and the junction
box.

The form contains a subform : results subform

My problem is that I have one patient with 2 seperate events (by Case No),
but the results keep combining in the form. So if I look up either case no,
results from both cases are there. I need to keep them seperate.
What have I done wrong?

thanks
Karen
 
I have a form based on two tables
Patient demographics table -primary key is Case No
Patient results table - primary key is Laboratory Number

I have used a junction box with both Case No and laboratory Number as
primary keys to create 1-many relationships b/w each table and the junction
box.

The form contains a subform : results subform

My problem is that I have one patient with 2 seperate events (by Case No),
but the results keep combining in the form. So if I look up either case no,
results from both cases are there. I need to keep them seperate.
What have I done wrong?

thanks
Karen
Click to expand...

Karen,
If you have a Demographics table and then a Results table, then as
long as "Case No" appears in the Results table, you can create a
relationship between the two tables and then have
main form: Demographics
subform: Results

and everything will be fine. You can have many events per patient (or
only one or none), and you'll only see each Patient record once.
 
Back
Top