RoryCrew
5 years agoQrew Member
Relationships - Parent, child and proxies
Def a noob question, but I've tried everything!
I have Registration Table:
Transfers table:
We get a list each month from suppliers of who they transferred money to in a month. We get:
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
------------------------------
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
------------------------------