LinkedIn
Twitter
I have an app that generates two kinds of reports each day. The two tables I am using are “Test Results” and the other is “Daily Report”
“Test Results” have multiple tests per day that make up one report. “Daily Report” is a single document generated daily.
I need to be able to sequentially number the reports. For instance, the “Test Results” report would be 0001 today and “Daily Report” would be 0002 today.
Tomorrow, “Test Results” would be 0003 and “Daily Report” would be 0004. So on and so forth…
I have a [unique] column and a [date:] column in “Daily Report” table, and I have a [key] column and [date] column in the “Test Results” table. I have been trying to figure this out using these but can’t get it right. Every day a new report will be generated HOWEVER not every day both of these reports will be generated. I will be adding more tables (one table = one report) so any advice on how to continue this numbering sequence using multiple tables would be hugely appreciated!!! Additional reports (tables) will be labeled “Field”, “Lab”, “Wet”, “Dry”
Could someone tell me if I am doing this right and help me please. Very much appreciated in advance!
