A new record with existing data

[johiot]

Hello,
I have a form with this fields:
patientID( primary key,autonumber)
cardcode,Pname,surname,age, address,phone,insertdate,sex.
I want when a patient is coming for second time and filling the "cardcode" ,Access to check and have a message like this

o you want to make a record with this patient? and to make a new record and keep only the fields Pname, surname,sex,phone, address.
Thanks a lot

 

[chrismcbride]

I imagine you would have a Patient visit form. You would have that form bound to your Visit table. You would also have a Patient form bound to a Patient table. On the first visit of a Patient you would have to add the Patient to you Patient table. At this time you would generate the cardcode (either automatically using an autonumber or manually ensuring that you can not have any duplication). Once the Patient is added you could open your Visit form on which you would have a Patient combo box. The box would be bound to the PK of your Patient table (cardcode) and would display the name of the patient. Once this is done then the Patient ID is stored with each Visit record. You will not need to store the Patient details as they are already present in the Patient table.
You may find that it is helpful to display this data so that the user who is making the new Visit record can verify the data. If the info is out of date or incorrect, you can put a button on your Visit form that will open the Patient form to the current Patient for editing.
HTH
Chris

 

[johiot]

You suggest me to make two tables and forms.
This is difficult because I must change the whole design of the database.

 

[Rich]

You'll have far more problems in the future if you don't structure your db correctly now as suggested