Hi,
Please share your ideas. I'm not sure if it is possible or not.
I have three tables Project, Budget, and Products. The Budget table has multiple fields that are linked to Project and Products, and the view of the Budget table is grouped by Project Name field. The Product table has multiple fields and one of the fields name is called Status. Whenever I create a new Project in the Project table. By default, Budget table should be updated with the New Project Name and integrate with Product table records that are in Status Active.