Forms Help

[misschanda via AccessMonster.com]

I have a form, the form has an ID that goes through many test/parameters. All
the test/parameters associated with the ID remains on a sub form for viewing.
I would like to develop a series (a-z) for each ID,were repeating information
for the id is carried throughout all ID's and the one test paramter that
differed, thus changing the Series Letter will be changed.

Do you have any suggestions.

Thanks
LA

 

[John W. Vinson]

I have a form, the form has an ID that goes through many test/parameters. All
the test/parameters associated with the ID remains on a sub form for viewing.
I would like to develop a series (a-z) for each ID,were repeating information
for the id is carried throughout all ID's and the one test paramter that
differed, thus changing the Series Letter will be changed.

Are you talking about storing information redundantly in every record of the
subform's table? If so, that's generally a very bad idea!

What are your tables? How are they related? Do you perhaps need another table
related one-to-many to the ID table, with a Series field?

John W. Vinson [MVP]

 

[misschanda via AccessMonster.com]

Maybe i should rephrase.
I have a form w/ many variables and their results and also parameters
settings. Each form is has its on ID. Because of needs of
customer/researchers an one variable in an ID can change however everything
else remains the same.
I would like for the system to automatically update, sort of like a Revision.
whenever you want to update the original it becomes locked and results in
Revision 1 and so forth.

 

[John W. Vinson]

Maybe i should rephrase.
I have a form w/ many variables and their results and also parameters
settings. Each form is has its on ID. Because of needs of
customer/researchers an one variable in an ID can change however everything
else remains the same.
I would like for the system to automatically update, sort of like a Revision.
whenever you want to update the original it becomes locked and results in
Revision 1 and so forth.

I'm sorry , this is even more confusing.

I have NO idea what you mean by "variable in an ID" or "sort of like a
Revision".

Do you want to keep the original data and also the changed data?
Do you want to just change a record in place?
Could you post an example of the data before and aftter the change?

John W. Vinson [MVP]