troubleshooting relationships and crossing records
Hi All,
I'm pretty new to building a database (a few months). As a result, I tend to try and try again - which has it's advantages and disadvantages. This system is so big that I'm getting myself confused and now have hit a road block on troubleshooting my issue (s). It could be several issues or one, I'm not certain.
Set-up:
GrandParent Table: Members
Parent Table: Services
Child Table: Charts
Each Member can have Several Services
Each Service can have several Charts
My form on the Member table should show all the associated charts for each service for each member.
Now, I've been going back and forth on this changing settings to make the relationships work, which I finally was successful. However, in the process, I've crossed members. Fortunately, this is all test data. On my first screen shot, you can see that Member Claude Schamba has multiple Charts with different related Member Names - none of which are him but should only be listed as him. In the second screen shot, you can see my Charting Home Table with records. Claude has 2 records listed among others listed.
I've checked the relationships between Member, Services & Charting and attached those screen prints. I am not sure if there is something else on the relationship that I am missing or if I changed a setting on the field settings or both.
Please help, I'm at a stand still and anything else I look at just confuses me more.
Cheers! Mary
------------------------------
Mary Perkins
M3TR1CS Business Solutions
mary.perkins@m3tr1cs.com
------------------------------
I'm pretty new to building a database (a few months). As a result, I tend to try and try again - which has it's advantages and disadvantages. This system is so big that I'm getting myself confused and now have hit a road block on troubleshooting my issue (s). It could be several issues or one, I'm not certain.
Set-up:
GrandParent Table: Members
Parent Table: Services
Child Table: Charts
Each Member can have Several Services
Each Service can have several Charts
My form on the Member table should show all the associated charts for each service for each member.
Now, I've been going back and forth on this changing settings to make the relationships work, which I finally was successful. However, in the process, I've crossed members. Fortunately, this is all test data. On my first screen shot, you can see that Member Claude Schamba has multiple Charts with different related Member Names - none of which are him but should only be listed as him. In the second screen shot, you can see my Charting Home Table with records. Claude has 2 records listed among others listed.
I've checked the relationships between Member, Services & Charting and attached those screen prints. I am not sure if there is something else on the relationship that I am missing or if I changed a setting on the field settings or both.
Please help, I'm at a stand still and anything else I look at just confuses me more.
Cheers! Mary
------------------------------
Mary Perkins
M3TR1CS Business Solutions
mary.perkins@m3tr1cs.com
------------------------------
