Hi, I am new to the group and this is my first post so hopefully I will get this done in a manner that allows for easy response.
Access 2016
I am working on a database to record and report lab data. I need to create an input form to enter the results of lab tests. I have these tables:
1. Table of analyses (many different analytical procedures may be performed)
2. Table of sample points (many different sample points may be sampled)
3. Join table for the two tables above since there is a many to many relationship
4. Table of lab report headers (customerID, sample collection date, and Sample Collector ID)
5. Table of lab report details (HeaderID, Analysis date, sample point ID, analysis ID, result)
Any of the analyses may be performed on any of the samples. However, I have several sets of samples and analyses that are frequently repeated. That is, certain sample points are collected every week and the same 6-8 analyses are performed on those samples each time. I know how to make an input form based on the join table to enter data, but that requires the data entry to be a little time consuming, having to select the sample pointID and analysis ID each time to enter the result. To simplify data entry for the repeated samples, I would like to make a form for each of those routine sample points that already includes the “normal” analyses so that the only manual data entry required is entering the result.
I have no idea how to start. Do I need to create another table? Table of “ testing templates” or something of that nature? And if so, what do I include in the table?
Is this too vague or too complex a question for this forum?
Thank you,
David
Posted by: David Pratt <david.pratt@outlook.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar