troubleshoot form


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
 
Ad

Advertisements

P

Piet Linden

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top