Linking of two tables

Hello

I am new to this plugin and trying to create a form based on a database table that contains job details such as job title, location, and job description. I also have another table called customers, which stores customer details.

I would like to link the job entry form to the corresponding company, ensuring that the form displays the company ID, name, and address for the user to select. Is this possible? (company 1-M jobs)

I watched your YouTube video on 1-M relationships, but I couldn’t find the ‘Data Project’ menu item in my interface. I also tried using the ‘relationship’ option in the form builder configuration, but when I linked the company to the job entry form, nothing happened. After clicking ‘Apply’, the relationship does not appear in the settings field, so I am not quite sure what it it is supposed to do.

I am currently using the Professional license. Could you please advise on how to achieve this?