My problem is three deep.

1- facility Candidatekey- facilityno
2- wellunit Candidatekey- facilityno+unitno
3- wellinsp Candidatekey- facilityno+unitno+dtos(inspdate)

?In the case of wellunit as parent to wellinsp, I think I'm stuck with using the candidatekey of facilityno+unitno. Am I not?

?Are you familiar with the I mentioned in same thread above by Tatum and Giesen that parses the tcFieldName parameter in a modified procedure RIUpdate? Would this be wise for a novice like me?

Thanks,Sylvia





>Hi Doug.
>Thanks for the great tools and clear explanations.
>
>(Please pardon my rudimentary questions)
>
>>It's best to avoid using compound (ie. more than one field) keys in joins between tables. Say WELLUNIT is the foreign key field to the other table. Create an index on it *and* create one on WELLUNIT + WELLINSP as your candidate key. Then, use the WELLUNIT tag for RI.
>
>
>? I chose 'Edit RI' and the Grid/Builder comes up, but I can't change the Tag values. How do I get back there?
>
>Thanks,
>Sylvia