uscctechnician
Technical User
Good evening,
I am running into a situation where I know I can solve my delema by creating multiple text fields in one table, but I think that would be so inefficient. So let me explain what I am trying to do and if anyone has a suggestion on how best to accomplish this, I would very much appreciate any guidance.
I have a form called "frmVisits" where I have 5 or 6 pages inside the form. One of the pages is called "Observations". I have 7 memo fields where each text field is a specific question or observation I am making on the employee. They all follow the format txtObserve_greeting, txtObserve_listening, etc...
I have one drop list on this page called cboTechnicians which is pulling data from a query result from a table.
The problem I am having is there may be anywhere from 1 to 3 employees I will be observing and all 7 memo fields apply. So I would select one employee, fill out my comments on each memo field. The problem lies in how do I set this up so if I select a second employee, the memo fields somehow update and change to show the new observations for the second employee.
My very beginner thought is set up three memo fields for each observation. I would set up a text box to select how many observations I am doing (1, 2 or 3) and based on that answer, have it hide or unhide additional pages, each having their own memo field. Page 1 has txtObserve_greeting1, page 2 would have txtObserve_greeting2, and page 3 would have txtObserve_greeting3. Each memo field is set to 300 characters since I do need to be able to input details.
But there has to be a more streamline method than what I mentioned above. I've been in the forum before, and have seen a lot of really smart users and mods in here. I am hoping anyone can give me a suggestion and steer me in the right path.
Thank you in advance!
I am running into a situation where I know I can solve my delema by creating multiple text fields in one table, but I think that would be so inefficient. So let me explain what I am trying to do and if anyone has a suggestion on how best to accomplish this, I would very much appreciate any guidance.
I have a form called "frmVisits" where I have 5 or 6 pages inside the form. One of the pages is called "Observations". I have 7 memo fields where each text field is a specific question or observation I am making on the employee. They all follow the format txtObserve_greeting, txtObserve_listening, etc...
I have one drop list on this page called cboTechnicians which is pulling data from a query result from a table.
The problem I am having is there may be anywhere from 1 to 3 employees I will be observing and all 7 memo fields apply. So I would select one employee, fill out my comments on each memo field. The problem lies in how do I set this up so if I select a second employee, the memo fields somehow update and change to show the new observations for the second employee.
My very beginner thought is set up three memo fields for each observation. I would set up a text box to select how many observations I am doing (1, 2 or 3) and based on that answer, have it hide or unhide additional pages, each having their own memo field. Page 1 has txtObserve_greeting1, page 2 would have txtObserve_greeting2, and page 3 would have txtObserve_greeting3. Each memo field is set to 300 characters since I do need to be able to input details.
But there has to be a more streamline method than what I mentioned above. I've been in the forum before, and have seen a lot of really smart users and mods in here. I am hoping anyone can give me a suggestion and steer me in the right path.
Thank you in advance!
