ContributionsMost RecentMost LikesSolutionsRe: Relationships - Parent, child and proxiesThanks appreciate it! I can't use the phone number as a primary key as it may change for some people. On the QSP front, I've contacted the makers of DC many to many, Veilsun and Juiced technology's triggers. Are there any others I should consider? Cheers Rory ------------------------------ Rory Crew ------------------------------ Relationships - Parent, child and proxiesDef a noob question, but I've tried everything! I have Registration Table: UUID [key], alphanumeric code means nothing Name Telephone number Transfers table: We get a list each month from suppliers of who they transferred money to in a month. We get: Telephone number Amount transfered Date of transfers I'd like the amount and date of transfer to appear in the Registration table. My issue is, I see Registration table as the Parent, and I can only create the relationship based on the key, which doesn't appear in table two. The phone numbers should match however. I've tried flipping the parent / child relationship around, that didn't work either. Any advice would be super helpful! (I tried using a third table that had UUID and telephone number, but this seemed overly complicated and was another dataset to maintain). ------------------------------ Rory Crew ------------------------------ Relationships - Parent, child and proxiesDef a noob question, but I've tried everything! I have Registration Table: UUID [key], alphanumeric code means nothing Name Telephone number Transfers table: We get a list each month from suppliers of who they transferred money to in a month. We get: Telephone number Amount transfered Date of transfers I'd like the amount and date of transfer to appear in the Registration table. My issue is, I see Registration table as the Parent, and I can only create the relationship based on the key, which doesn't appear in table two. The phone numbers should match however. I've tried flipping the parent / child relationship around, that didn't work either. Any advice would be super helpful! (I tried using a third table that had UUID and telephone number, but this seemed overly complicated and was another dataset to maintain). ------------------------------ Rory Crew ------------------------------