How to get Access to fill in demographics?

[Guest]

I want to create a table with customer information. Then I want another
table that allows me to enter "visit" data. I want to be able to bring up
the demographics from table 1 into table 2 (visit data) so I don't have to
type in demographics every time. Please help.

 

[Roger Carlson]

What you really want is to have all of your Patient data in one table and
all your Visit data in another. Then use a Form/Subform arrangement. The
Form will be bound to the Patient table and the Subform will be bound to the
Visit table. Then for each patient, you can enter multiple visits without
duplicating data.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "FormSubform" which illustrates this. You also might want to
look at the Books.mdb sample as well.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L