Linking Tables

[Guest]

I have several tables that are related by MedicalRecord. Some tables are
Demographics, Referral Type (where patient is referred from), Patients PCP
(Patients Primary Care Provider info), etc. I am going to create a form that
a user can type in all this information. Is there a way that when the user
inputs the MedicalRecord that each table will identify that MedicalRecord and
put the correct information in the corresponding table? Thanks in advance.
Ryan

 

[John Vinson]

Is there a way that when the user
inputs the MedicalRecord that each table will identify that MedicalRecord and
put the correct information in the corresponding table?

Yes. Use a Form based on the MedicalRecord table, with Subforms based
on the related tables.

If you're copying information other than the unique MedicalRecordID
into the related tables - DON'T. They should have *only* the linking
field and the fields pertinant to that table; you should NOT copy any
other fields into them.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

John,
Even before I received your reply I was able to link my tables on the
MedicalRecord and created forms/subforms that displayed all my data. I have
been a "dabbler" with Access for sometime and I still don't "trust" myself.
Thank you for your time I do appreciate it!

But I do have a question! I am starting to go into the world of VBA. (If
Access wasn't enough.) I am trying to write code so that when the user clicks
the close button to close the program, it will also save everything that the
user has done to that point. Possible? I am reading all my books and going on
the net.....help? Thanks so very much, Ryan

 

[John Vinson]

I am trying to write code so that when the user clicks
the close button to close the program, it will also save everything that the
user has done to that point. Possible?

It's possible, with some effort, to write code to PREVENT Access from
saving everything - an action which occurs by default, and requires no
code at all.

Each record is saved automatically, the moment the user moves to a new
record, closes the form, or closes the database.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Thank you for the insight. Until next time...

Ryan