Hi,
I have a base that contains three tables (Inventory, Budget, and Invoice) in my workflow I select items from the inventory manually and add them to the project budget. After adding them, I have a checkbox field in the budget table that is titled “billable” I am wondering if there is a formula that I can implement on the Invoice table that will automatically pull in a record from the Budget table IF the checkbox on Budget is marked as billable. At the moment, all I see is the potential of doing linked records, but this would mean clicking each one by one with very little ability to verify that I have moved over every single applicable item.
Any help you can offer is greatly appreciated!
J
