Log In

Log In



Not registered yet?


Reset password Activation link

How to link forms in QuintaDB

In order to link tables in QuintaDB you have to add Relationship field in Fields menu and configure it.

In order to link forms in QuintaDB you have to:

 

- go to Fields menu

- create new field with Relationship type, select form with which to link current form and relaitonship type. Also display field type.

 

How to link tables in MTH

 

Relationship type can be:

 

- one-to-one

- many-to-one

- many-to-many

 

Display type can be:

- Dropdown

Multi Select with autocompletion

 

Please, click here to watch screencast (without sound), where you can see how to link Team and Player forms.

 

In order to show several column's data from linked table you can create Formula field and select this field in 'Select display field'.

In QuintaDB you can have only one relationship between two forms.

 

 

 


Please, login to QuintaDB to be able to post comments

Igor Petrushenko

Hi, Jay!

Thank you for your interest in QuintaDB.
You can set only one relationship between two forms.
But you can have as many as you need such fields on your form, which will link to another forms.

Once you add relationship field to your form you’ll be able to also show as many as you need columns from linked form using Formula field. Please, see this link.

And also use that columns as formula operands.

Hope it helps! Please, let me know if you have any questions.


Is there any way that we could have more than one relationships. I was so impressed with QuintaDB and my form needs minimum 3 relationships. If restricted to one relation ill have to keep using my existing provider.

Share the discussion in the social networks: