Hello
I'm trying to create a database in as dynamic a way as possible so that any changes can be managed by people that aren't me basically, i.e. people who have little to no experience of access.
So for the purposes of explaining my quandary, we have a table of Criteria, a table of MeasurementTypes, a table of MeasurementTypeValues, a QALog and a QAScoreLog.
What I want to do is create an entry in the QA Form that provides basic information of the person being QAd and the channel the QA is being conducted on.
I then want a subform to open up that will display a list of the appropriate criteria - the criteria should be looked up against the 'ActiveCriteria' query (this could be five, ten, fifteen results etc.), and only return results where Channel matches the QA Form. This is the first problem - how do I get a Form to display a dynamic number of fields and list the results of a query? I tried a continuous form, that isn't possible due to the other issues I have.
I then want the user to able to assign a score to each of the criteria. This is dependent on the MeasurementType of that Criteria. This is then looked up against the MeasurementTypeValue table to find out which values should be listed in the combo box, such as 'Yes';'No';'N/A' or 'pass';'fail';'N/A' or '1;2;3;4;5' etc.
I then intended to have a query append both the criteria used and the score given to the 'QAScoreLog', with the main details being appended to the QALog - both obviously linked together by an ID from the QALog.
I'm a little stumped and would appreciate any advice you could provide!
Thanks