Automatically update clients details based on name chosen?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope someone can help me with this; I'm trying to put together a database
for a healthworkers Cardiac Rehabilitation Program, using Access 2003 (in
access 2000 format). I have several tables/forms, one of these holds patient
demographic information, the others hold program attendance information.
What do I need to do so that when the database user selects a patient in one
of the program attendance forms, their demographic data is automatically
updated? So if say, I were recording gym program attendance for example, and
I select a patient from the combo box, can I have the gender, d.o.b and other
fields update with info from that patient? I'm new to Access, and VBA looks
like greek to me but if anyone can help this helpless access user I'd owe
them a beer (or twelve) Thank-you!
 
You could do that, but you shouldn't.

Storing the data redundantly in more than one table is never a good idea. If
it disagrees between the tables, which one is correct?

Just keep the data in one table (presumably the Patient table). You can
create a query that joins that table to other tables, so that you always
have the relevant information available to you.
 
I see (said the blind man...) The only reason I wanted this demographic data
listed in other tables was so I could run queries that would give me
demographic breakdowns of who attends what; But you're saying I can use a
query to grab this data from several tables at once? You can tell I'm an
access newbie... Thanks for your help I'll give it a try.
 
Back
Top