Relationships

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.

Are you saying that you have 5 agreement tables? If so, you need 5 checklist tables.

In reality though you should probably have one agreement table and onechecklist table. Then you need a table that is a junction table so you can store the answer to the checklist for a specific agreement.

Like the other have stated, ...we need more info.
Is there, ... and wil there always be, only 5 agreements?
Is the "Checklist" one entiy?, ...or is a checkilst a set of enties (1 agreement with one checklist of multiple items)
...etc
Can you provide a detailed explanation of Agreements and Checklists, using a real world scenario?
But to me, ...it seems like a Many-To-Many...
Something like this roughly...?

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…

I see at least one EE question a week that pertains to using temporary tables in MS Access. But surprisingly, I was unable to find a single article devoted solely to this topic.
I don’t intend to describe all of the uses of temporary tables in t…

In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…

Using Microsoft Access, learn some simple rules for how to construct tables in a relational database.
Split up all multi-value fields into single values:
Split up fields that belong to other things into separate tables:
Make sure that all record…