Dynamically linking fields to forms

[mls via AccessMonster.com]

In my form I have patient_Id as drop down list which is linked to main
PATIENT table where it gets update by different department and the new values
shows up in my FORM's drown drop list immediately. Along with patient_id I
have 4 more values that need to be shown on my FORM from 4 different tables.
Finally all the above values collected dynamically and some tested values
from FORM base table ( testing table) should be saved into my testing table
when some one clicks on the save button.

Is this possible? with out distrubing the PATIENT tables or any other linked
tables?

 

[Daryl S]

MLS -

I am not sure if you have one application that is used to maintain these
tables, or if they are maintained elsewhere. I understand you have a test
table that you would like populated with information from the other tables as
they are updated. If this is all one application, then when a user hits the
'Save' button, you can code data to be entered into multiple tables (though
that is usually not a good idea from a database standpoint). Is there a
reason you can't use a query to get the data you need from the existing
tables?

If there is really a good reason to put the data into your test table also,
then you would add code behind the 'Save' button as follows: open your test
table; add a new record; set the values of the fields in this new record to
be those on the form; update the record; close your test table.

Again, I would suggest using a query to populate your test table, but I
don't know your business need for the data...

 

[mls via AccessMonster.com]

Hi Daryl, Rarely lab tech change one or two digits in the patients id while
entering the test results into the form. To avoid typing errors, as well as
to make the data entry simplified I am trying to fill few filelds (
demographic details like address, age , sex)from the other existing tables
which are updated by other departments. Lab tech wants to see all the
relevant patients details they are testing to be stored in a single table.
For ex: Master Patient table has 100 patients details but lab tech need only
15 patients details so they want all these details stored in one Testing
table. As they do analysis on these 15 patients only.
Currently I have patient id as a drop down in my form and in the patientid
control property for data source-: I am using a query to get all the patient
id from Master Patient table. Like wise I have 2- 3 fields from other tables
when lab tech click the save form button the patient id, demograpy data and
form test values are store in TESTING table.

Hope I explained your question.

MLS -

I am not sure if you have one application that is used to maintain these
tables, or if they are maintained elsewhere. I understand you have a test
table that you would like populated with information from the other tables as
they are updated. If this is all one application, then when a user hits the
'Save' button, you can code data to be entered into multiple tables (though
that is usually not a good idea from a database standpoint). Is there a
reason you can't use a query to get the data you need from the existing
tables?

If there is really a good reason to put the data into your test table also,
then you would add code behind the 'Save' button as follows: open your test
table; add a new record; set the values of the fields in this new record to
be those on the form; update the record; close your test table.

Again, I would suggest using a query to populate your test table, but I
don't know your business need for the data...

In my form I have patient_Id as drop down list which is linked to main
PATIENT table where it gets update by different department and the new values

[quoted text clipped - 6 lines]

Is this possible? with out distrubing the PATIENT tables or any other linked
tables?

 

[Daryl S]

MLS -

OK, if you need this table, then you can append records to it through code.
I assume you have properly created the table with a primary key and all the
fields you will need.

You can append the new data to the table with a query or through code,
pulling information from the form and/or other tables as necessary. If you
build an append query, then you can reference the fields on the form where
needed, and join in other tables (like patient information if it is not on
the form) using the key values on the form (e.g. patientID). To get the
information from the form, while in the query design grid for the field name,
click on the build button (has elipses (...) on the button), and on the left
side choose forms and navigate to your form and the field on the form you
want to include. Start small and look at the information in data sheet mode
as you go before running the append query.

If you do this through code, then you will need a pretty good handle on SQL
statements and recordset processing, but there is a lot of information and
sample code pieces in the Microsoft Help and online for that. You would be
doing a similar thing referencing the values on the form where needed, and
pulling from other tables where needed.

Hope that helps!

--
Daryl S

Hi Daryl, Rarely lab tech change one or two digits in the patients id while
entering the test results into the form. To avoid typing errors, as well as
to make the data entry simplified I am trying to fill few filelds (
demographic details like address, age , sex)from the other existing tables
which are updated by other departments. Lab tech wants to see all the
relevant patients details they are testing to be stored in a single table.
For ex: Master Patient table has 100 patients details but lab tech need only
15 patients details so they want all these details stored in one Testing
table. As they do analysis on these 15 patients only.
Currently I have patient id as a drop down in my form and in the patientid
control property for data source-: I am using a query to get all the patient
id from Master Patient table. Like wise I have 2- 3 fields from other tables
when lab tech click the save form button the patient id, demograpy data and
form test values are store in TESTING table.

Hope I explained your question.

MLS -

I am not sure if you have one application that is used to maintain these
tables, or if they are maintained elsewhere. I understand you have a test
table that you would like populated with information from the other tables as
they are updated. If this is all one application, then when a user hits the
'Save' button, you can code data to be entered into multiple tables (though
that is usually not a good idea from a database standpoint). Is there a
reason you can't use a query to get the data you need from the existing
tables?

If there is really a good reason to put the data into your test table also,
then you would add code behind the 'Save' button as follows: open your test
table; add a new record; set the values of the fields in this new record to
be those on the form; update the record; close your test table.

Again, I would suggest using a query to populate your test table, but I
don't know your business need for the data...

In my form I have patient_Id as drop down list which is linked to main
PATIENT table where it gets update by different department and the new values

[quoted text clipped - 6 lines]

Is this possible? with out distrubing the PATIENT tables or any other linked
tables?

--



.