0

Specific field in multiple tables

I want to set up a database with 3 tables: Client details, Workflow and Invoicing. I want specific fields from both Client Detaisl and Workflow to appear as fields in Invoicing. For example, in Invoicing I want there to be a field called Master 01 Title which already exists in Workflow. Later, there would be a line called Master 02 Title that also already exists in Workflow. And so on. How do I link the tables so that I can select only some of the Workflow field to appear in Invoicing?

Reply

null