I did as per your second advice. bound the form to the destination table. The records having the status "draft" until clicking the "save" button. So excluding the records with the draft flags for other purposes. Now successfully achieved the intended result without any issues.
Having a scenario where to auditors review and score different questions under few categories.
I would like to mark the category as per the below criteria.
if any of the questions in a particular category is "Not Complaint" then the category is "not compliant".
If all the questions in the...
I agree with this. However, there is a challenge to implement individual copies for each user. Users float in every department and they always not copying the front end to their location. I will try to implement your advice, but need a workaround as well.
It's a survey table. user will answer certain questions and at the end of the survey, the value stored in the temp table should be transferred to the original.
I made this to avoid inserting an incomplete survey in the original table.
the reason it is not unbound is, there is an option group...
I use a temporary table to store values from the form and when the form closes, transfer temp data to another table and clear the temp table. This works fine if one user working on it. If multiple users working on the same front end, then throws a tricky scenario.
How to solve this scenario...
This counts all the records of Data.Category. I wish Category should be counted only once for each group of Data.ItemName.
Suggestion by @June7 works fine. out of curiosity, I am thinking about how to make this work in a single query.
I would like to generate the number of category occurrences in a particular month for the below example table. I think it can be done via DSUM/DCOUNT but couldn't able to achieve. Please help.
Looked at this; seems more advanced level for me.
My concern is a simple task. There are certain items due on each user every month. These due items are already filtered and available as a query. Now, how to send reminder emails to each user with the items only due for them?