Am I taking the right approach?

[JM1234]

Hi,

I’ve created a base for tracking creating and programming events

Tab 1 - List of Events
Tab 2 - List of Event Costs
Tab 3 - Each cost is linked to an individual event i.e (‘Event 1 Travel Costs’) which creates a ledger for attaching paperwork etc

At the moment, when an new record is created in tab one, an automation creates around 80 new records which links each cost to the new event.

Is this the correct or is there a simpler or better way to do this?

[Williams_Innova]

Where is the automation creating the new records?

Based on the description you provide, I’m not sure why you need the 3rd tab. I would think you could link Events (tab 1) to Event Costs (tab 2).

Honestly, I will need more context for any more insight.