ContributionsMost RecentMost LikesSolutionsRe: Establishing relationship automaticallyYes, you can set a text field to be the parent table's key field. If you do, then your reference field would also be text. I like how you're thinking about this, and I recommend building a pipeline to fill in that reference field. The pipeline would trigger when the record is created, and move the text value into the reference field. That way it will be consistent, even when your users are in Grid Edit mode. ------------------------------ Brian "Actual" Cafferelli ------------------------------