Special Form

[Loi]

Hi,
I create a data entry form which has 10 text boxes to
enter information in such as : Patient's Birthday , Time
visit, SS # .....

I think that it saves me a lot of time if the data entry
form keeps the SS# and Birthday so that each time I
enter patients, who names already on the list , I don't
have to type their SS and Birthday again and again.

Please show me how to do it. Coding?

Please tell me how.
Thank you
Loi

 

[Rick B]

You do not want to enter redundent data in a table. In your example, a
patient that comes in 20 times will have their SS# and Birtdate in the table
20 times. Instead, you need multiple tables. The 'patient' table would
contain information on the patient (only one record per patient). The
'appointment' or 'visit' table could contain the visits and be linked to the
patient table. This is a classic one-to-many relationship.

Rick B


Hi,
I create a data entry form which has 10 text boxes to
enter information in such as : Patient's Birthday , Time
visit, SS # .....

I think that it saves me a lot of time if the data entry
form keeps the SS# and Birthday so that each time I
enter patients, who names already on the list , I don't
have to type their SS and Birthday again and again.

Please show me how to do it. Coding?

Please tell me how.
Thank you
Loi