M
mls via AccessMonster.com
Access forms/subforms and data entry..
I created lab id and test_no as composite primary key because each patient
can be tested upto 3 times so labid & test_no should be unique for each
patient in testing_table.
I have created a form with lab id as drop down list which should be updated
dynamically when LAB tables gets updated every day. Instead of me typing the
lab id. And test_no is also a drop down list with 3 standard values. And I
have all vitals values taken at each test_no. When I try to insert new values
for a particular patient using find command when I go to specific record and
change the test_no and enter vital values my original record is updated. So I
am using create new record for the same person by clicking on new record in
the record navigator, the problem is all the fields are empty even though the
patient id exist.
My question:
1) How can I dynamically link my lab id to LAB table? So that it gets updated
every time we open the form.
2) How can I get all the existing values for this person from his previous
record when some one types the existing lab id?
I created lab id and test_no as composite primary key because each patient
can be tested upto 3 times so labid & test_no should be unique for each
patient in testing_table.
I have created a form with lab id as drop down list which should be updated
dynamically when LAB tables gets updated every day. Instead of me typing the
lab id. And test_no is also a drop down list with 3 standard values. And I
have all vitals values taken at each test_no. When I try to insert new values
for a particular patient using find command when I go to specific record and
change the test_no and enter vital values my original record is updated. So I
am using create new record for the same person by clicking on new record in
the record navigator, the problem is all the fields are empty even though the
patient id exist.
My question:
1) How can I dynamically link my lab id to LAB table? So that it gets updated
every time we open the form.
2) How can I get all the existing values for this person from his previous
record when some one types the existing lab id?