I have a service and repair app. Some tech’s do both service work and Repair work. The work is on two different tables. I created a Tech tab were they can see what jobs they have open and would like to pull from those two tables based off the user name.
Thanks for the HELP
Have a User email in these tables so that you can find them.
I would suggest having only one table for services and repairs and adding a Type column to indicate what it is… that would make your Data much easier to manage.
This . Especially if both tables include identical fields/columns (date, car make, car model, type of repair/service, etc.)