so I have the issue that I have users in one table (I) and referrers in another (II). Now I want to the referrer`s count (table II) of referrals to increase every time a user enters his refer-ID (Table I).
From what I gather this should work through linking refer-ID in Table I to table II through “Link to another record” but it deletes all of the records existing in it so far instead.
Is there no way to simply count in one table how often a respective ID from another table shows up?
Thanks a lot for your help