Hello experts, I have a checklist for each agreement. There are 5 agreements. Shouldn't I make one table for tblChecklist that contains ALL records and have a combo box for the selection of which agreement the checklist belongs to?
Someone posed to me separate tables and I don't think I can do this because I don't see how. If I wanted to develop a query for ALL checklist records I would have to somehow relate them in the query builder window (ie define the relationship). At least I think. If not there would be duplicates.
How would an expert do this? One table or separate? As I mentioned the data is similar in that each is a checklist item but I have 5 agreements. The only real difference is one item is a checklist item in agreement 1 and another might be tom agreement 2. Etc etc.