Hi guys,
Is it possible to have duplicate relationships for two tables. I have two tables : MEMBERS and COUNTIES. I am using a relationship to generate a drop down list for one field in the MEMBERS table from the contents of the COUNTIES table. I want to use the COUNTIES table to do the same again but, for a different field in the MEMBERS table.
Does that make sense? Is it possible? At the moment all it does if I try to create another relationship for the different field, it updates the original MEMBERS-COUNTIES relationship.
Cheers,
Hannah
Is it possible to have duplicate relationships for two tables. I have two tables : MEMBERS and COUNTIES. I am using a relationship to generate a drop down list for one field in the MEMBERS table from the contents of the COUNTIES table. I want to use the COUNTIES table to do the same again but, for a different field in the MEMBERS table.
Does that make sense? Is it possible? At the moment all it does if I try to create another relationship for the different field, it updates the original MEMBERS-COUNTIES relationship.
Cheers,
Hannah