SyaefulBahri3
6 years agoQrew Trainee
Join Existing Data
Hi All, I have 2 tables: Employee Table and Vendor Table. Employee table consists of Employee Name field and Vendor Table consists of Vendor Name field. There is Payment table consists of Pay t...
- 6 years ago
I think the easiest way to accomplish this would be to create relationships between the tables and use form rules to have the user choose if they are paying a vendor or an employee.
- Create a pay to field that has a choice of employee or vendor.
- Create a relationship between Payments and Employees with Payments as the parent
- Create a relationship between Payments and Vendors with Payments as the parent
- On the Payments table set a form rule to show:
The other option is to create a payees table and then create a relationship to the employees, vendors, and payments tables and then create an automation to add a record to the payee table each time a vendor or employee is created.
------------------------------
Debbie Smith
Certification Program Developer
Quick Base
Plymouth MA
2394106333
------------------------------