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
------------------------------
