Hello, Hopefully someone can help me with this.
I'm using this database to submit a form and emailing it.
It was simple how i was using, I had a table and depending where they where going the requirements where put in the form and emailed.
Well now I run into a problem where they might already have a certain test done within a year which are all valid for 1 year. So I decided to add another table that shows what test was done each time I submit a request.
How can I compare what was done and what will be needed before i submit the request?
I'm currently using vba to fill in the form and emailing.
This is an example of the table
In both tables, all fields are Yes/No except for the Datefield,SiteLocation
tblTestRequirements
SiteLocation
Test1
Test2
Test3
Test4
etc*
tblTestTaken
DateTaken
Test1
Test2
Test3
Test4
etc*
I'm using this database to submit a form and emailing it.
It was simple how i was using, I had a table and depending where they where going the requirements where put in the form and emailed.
Well now I run into a problem where they might already have a certain test done within a year which are all valid for 1 year. So I decided to add another table that shows what test was done each time I submit a request.
How can I compare what was done and what will be needed before i submit the request?
I'm currently using vba to fill in the form and emailing.
This is an example of the table
In both tables, all fields are Yes/No except for the Datefield,SiteLocation
tblTestRequirements
SiteLocation
Test1
Test2
Test3
Test4
etc*
tblTestTaken
DateTaken
Test1
Test2
Test3
Test4
etc*