Automatically duplicate record in one table into another

Hello! Sorry if this has been asked before, searched through the forums and didn’t quite find the answer I needed to solve my problem.

Context

I have an Inventory Tracking base with multiple tables inside. One of the tables is a Purchase Orders table to which I add any purchase I made. The problem is that it’s getting very lengthy and I’d like to break out all the sales and profit information into it’s own table.

Want

What I’d like to do is create a Profits table and have it automatically pull in every record from the Purchase Order table. Ideally I’d like to do this without any 3rd party tool as it will allow me to share this template with my friends and have it just work out of the box.

Thanks in advance for any help!

Ah looks like I just found my answer. It’s not possible but instead a new view might work instead: Automatically populate records from one table in another table

1 Like