Z
zSplash
I'm so totally "not getting" this -- hope someone can help.
I have 4 tables (tCase, tDates, tMtgs, tNames). The first 3 tables are
directly related (ID to ID, one-to-one), and have referential integrity.
The tNames table has multiple names that go with the tCase table, so I've
related tNames.fk to tCase.ID in a one-to-many relationship. There are 1237
records in my database.
I created a query of all 4 tables (qAll). In this query, I joined all 4
tables with the first join property: "Only include rows where the joined
fields from both tables are equal." (This query has 3068 records, although
my database only contains 1237.)
So, then I make a form, based on qAll, and it, too, has 3068 records
(instead of the 1237 records of my database). I want to only have 1237
records in my form (until more are added), not 3068. What have I done?
TIA
I have 4 tables (tCase, tDates, tMtgs, tNames). The first 3 tables are
directly related (ID to ID, one-to-one), and have referential integrity.
The tNames table has multiple names that go with the tCase table, so I've
related tNames.fk to tCase.ID in a one-to-many relationship. There are 1237
records in my database.
I created a query of all 4 tables (qAll). In this query, I joined all 4
tables with the first join property: "Only include rows where the joined
fields from both tables are equal." (This query has 3068 records, although
my database only contains 1237.)
So, then I make a form, based on qAll, and it, too, has 3068 records
(instead of the 1237 records of my database). I want to only have 1237
records in my form (until more are added), not 3068. What have I done?
TIA