Help to create database and form

[CarlettoFed]

To be SOP all eight validations must be set to done or is Ruggdness validation sufficient?

[Avogadrow]

All items of validation should be passed to issue the SOP

[CarlettoFed]

In the attachment you will find a possible solution to your problem.

AnalysisManagement.zip

[Avogadrow]

Dear Carlettofed,
I have no words to say thanks. your work is very appreciated.
Some bugs appears during operation like the attached screenshot.

[CarlettoFed]

Attached find the update.

AnalysisManagement.zip

[CarlettoFed]

Further update.

[Avogadrow]

Dear CarlettoFed,
Thank you fro helping me.
could you please check my attached DB. I changed the structure that I sent to you before.
my structure now is
Product name ...then....Method name (instead of many components, now i created it as : the method name is assay of vit B1, B2, B6)..then..... Validation (all items of validation like forced degradation)...then... Forced degradation (all items of forced degradation like HCL).
I am working to link the SOP now.
the main form is the "frmproducts" this form is created to enter your data and save.
my problem now, I am trying to create a form or query to help me if i need to know the status of one of the listed products in the DB.

[CarlettoFed]

Meanwhile, when you ask for something, you need to be clear from the beginning, so as not to waste time.
Now in fact you have introduced:

Validation options

the possibility of excluding a Validation from SOAP control, having introduced the "Not Requiered" option.

having introduced the Forced Degradation

which involve a change:

the structure of the tables
of the structure of the masks
the modification of the code

[Avogadrow]

I was clear from the beginning, I need to learn how to create such database. so when you sent your kind version, I tried to create new one like it but I cannot due to the lack of mu experience so I changed the structure to make it easy to apply for me.any way I am sorry for wasting your time!