If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
troubleshoot form
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 |
#2
|
|||
|
|||
troubleshoot form
On Aug 29, 6:02*am, Karen wrote:
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. |
Thread Tools | |
Display Modes | |
|
|