I have a pretty basic table that I keep my Bourbon inventory. I have a table called “bottles purchased” and another called “current inventory”. They are basically the same tables right now, as I just duplicated my original table, Bottles Purchased. In my table, I have a checkmark field that I check if it’s currently in my collection. Obviously, I can filter the checkmark on and off. But how can I add a bottle in “bottles purchased” and it gets added to my “current inventory” table upon checking the checkbox?
Hope that makes sense.