If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Dynamically linking fields to forms
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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#2
|
|||
|
|||
Dynamically linking fields to forms
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... -- Daryl S "mls via AccessMonster.com" wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 . |
#3
|
|||
|
|||
Dynamically linking fields to forms
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. Daryl S wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#4
|
|||
|
|||
Dynamically linking fields to forms
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 "mls via AccessMonster.com" wrote: 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. Daryl S wrote: 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? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 . |
Thread Tools | |
Display Modes | |
|
|