I’m trying to create a base with two sheets in it to track my online subscriptions, ie:
However while I’ve used the linking to other records feature before I just can’t get my head around another way to do this as Airtable doesn’t let you link primary fields and the record that makes the most sense to me in both sheets is the name of the product/company
So for example 1Passwords AgileBits and TextExpander is Smile Software but with my Ancestry subscription the company is also called Ancestry.
For clarity the main sheet is going to list “Software, cost, date of renewal and is the sub active or not” the second sheet was going to have company details ie support phone/email and notes on how to cancel the sub if I should want to.
How would you go about linking these two tables?