This might not work, but thought I would ask just in case:
I have a base that has all of my clients & projects broken down in and then I have another base that I have all of my promotion broken down in. In my promotion base I want to come up with an ROI that updates automatically.
So I was wondering if there is a way to somehow relate the table that have my promotional information in and a table that has my client information in so I can link the ad campaign that got me that client and in turn have the money I make overtime with that client show next to the campaign it’s linked to so I can create a formula field to show an ROI that updates on its own next that specific campaign.
