Hi there -
When I add the following tables to a query design and the fields from these tables - it works fine (i haven't listed all the fields in the tables, just the primary keys to illustrate how the tables relate to each other)
TABLE 1:
MAIN_ID
TABLE 2:
FISH_ID
MAIN_ID
TABLE 3:
IND_FISH_DATA_ID
FISH_ ID
I however would like to add the following table to this query
TABLE 4:
CAPTURE_METHOD_ID
FISH_ID
(Table 4 is join table that links a lookup table(table 5) to Table 2)
Table 5: (lookup table)
CAPTURE_METHOD_ID
DESCRIPTION
Can you tell me why adding table 4 screws up my query? Can you have a query that contains 2 tables joined to the same table?
It seems to me that if adding table 4 to my query screws it up (i can't access the records in the table and how they related to the other tables), then this table isn't really helping me much!
How can I relate my tables so my query works? What do I need to change?
Please help!
Thanks for reading all this and answering
Sue
When I add the following tables to a query design and the fields from these tables - it works fine (i haven't listed all the fields in the tables, just the primary keys to illustrate how the tables relate to each other)
TABLE 1:
MAIN_ID
TABLE 2:
FISH_ID
MAIN_ID
TABLE 3:
IND_FISH_DATA_ID
FISH_ ID
I however would like to add the following table to this query
TABLE 4:
CAPTURE_METHOD_ID
FISH_ID
(Table 4 is join table that links a lookup table(table 5) to Table 2)
Table 5: (lookup table)
CAPTURE_METHOD_ID
DESCRIPTION
Can you tell me why adding table 4 screws up my query? Can you have a query that contains 2 tables joined to the same table?
It seems to me that if adding table 4 to my query screws it up (i can't access the records in the table and how they related to the other tables), then this table isn't really helping me much!
How can I relate my tables so my query works? What do I need to change?
Please help!
Thanks for reading all this and answering
Sue
