You are not logged in. Please login or register.
My Visual Database → FAQ → Need Help
Dear Sirs,
I need help with my project I need, I create a project to save data for participants in one of our services.
the service depends on saving multiple readings for participants four times every year.
the problem is when I want to open a new year and save Reading for a new year without deleting the previous year's reading.
Can Anyone help me with this problem, please?
Hi Alaa,
Can you upload your project (delete the .exe file and zip the remaining files).
Then someone will be able to have a look.
Derek.
Thank you
This is my project
dose.rar 298.05 kb, 279 downloads since 2021-09-04
Hi,
You need to change your data schema.
Basically, all you should hold in your 'participants' table is their personal details, department, position etc.
Any data that relates to results (dates and reading) needs to go into a new table (which I've called 'year') which is related to the 'participants' table.
This allows you to hold multiple 'year' results against the same participant.
Please have a look at the attachment.
I've had to quickly change a lot of your forms (mainly the columns in the tablegrids) so you will need to go through them all again and check what you want to add in or take out.
I also removed your duplicate check temporarily so that I could test what I'd changed was working okay. Just put it back in when you need it.
Regards,
Derek.
dose2.zip 345.85 kb, 283 downloads since 2021-09-05
Thank you, Sir, It is a cleaver Way.
My Visual Database → FAQ → Need Help
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi