Re: Populating a record on different forms
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 03 Nov 2006 19:10:07 -0700
On Fri, 3 Nov 2006 15:26:02 -0800, Ramtin
<Ramtin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have created 7 tables and I defined a primary key which is similar in all
tables, my primary key is Medical record number of patients which is specific
for each person and I can make queries based on this number( If I made a
mistake please give me the hint) when database is complete. so I made forms
according to these tables, now what I am trying to do is just asking the
users to enter this number once so it is automatically appears on following
forms until all data entered.
I have one more question: How I can make a command button perform 3
different task with a click( save and close the current form and open the
following form). it seems every button just do one command.
How do these seven tables differ? It would be EXTREMELY unusual to
have seven tables all with the same Primary Key. This would mean that
each patient would have one, and only one, record in each table.
Surely in a medical records application each patient might have
multiple Diagnoses, Visits, attending physicians, and so on? If so,
then you should have the PatientID as a *foreign* key - a linking
field, not the primary key - in multiple tables; but you would not
need or want to create "placeholder" records with just the patientID
in these tables.
John W. Vinson[MVP]
.
- Prev by Date: Re: Automation
- Next by Date: Image control button to add images
- Previous by thread: Re: Populating a record on different forms
- Next by thread: Re: Populating a record on different forms
- Index(es):
Relevant Pages
|
