Log In

Log In



Not registered yet?


Reset password Activation link

Forums ~ Noticed some issue with QuintaDB?

multiple relationships
October 10, 2017
Completed
0
 

linksmj@gmail.com
October 10, 2017

I read there can only be one relationship between tables but does that mean can there be more than one many-many relationship for a table.
I want to have a structure that is like “parent-child- grandchild” where the relationship of the child table is many to many in both directions. When i try to do this the forms are not available from the drop box. Also when looking at the page forms for my database there are no relationships showing – the only way to make these appears to be by making a new field?
it looks different on the screencast.
Thanks
Matthew



Igor Petrushenko
October 10, 2017

Hi, Matthew!

Yes, you can create only one Relationship between table A and B.
If you want to show more field from table B in table A you have to add Formula field to table A,
which can use any of the B table’s fields as operands.



Igor Petrushenko
October 10, 2017

So if your task is to link tables A→B→C you’ll:

1. Create relationship between A & B, B & C.
2. Create Formula in table B named let’s say ‘C field’.
3. Create Formula in table A which will use formula field ‘C field’ (from step 2) from table B in order to show C fields data in table A.



Reply:

File attachment (max 10MB)




Share the discussion in the social networks:





Tags

#Android

#CSV

#Can't be blank

#Excel

#Export

#Google

#HIPAA Compliance

#HTML

#IP

#Import

#Mobile

#PCI compliant

#QuintaDB

#SMS

#URL

#access rights

#account

#actions

#activation

#activity

#advanced options

#api

#attach

#autocomplete

#autoincrement

#background

#backup

#birthday

#blocked

#boolean

#browser

#button

#calendar

#captcha

#chart

#checkbox

#clone

#close the form

#cms

#color

#column

#conditional formatting

#confirm

#constant

#cookies

#country

#crm

#css

#custom

#data security

#database

#date

#date & time

#date format

#description

#dropdown

#dublicate

#duplicate

#dynamic form

#email

#example

#extract

#field

#field names

#field type

#file

#file upload

#filter

#font

#form

#form builder

#formatting

#formula

#forum

#free

#ftp

#gap

#geolocation

#grouping

#horizontal

#id

#iframe

#images

#in-place editing

#instruction

#integration

#invite

#java

#js

#language

#limits

#link forms

#links

#location

#log

#login

#logo

#map

#mc access

#members

#moved form

#moved project

#ms access

#multi-input

#multiline field

#multipage form

#multiple

#multiple forms

#mysql

#new features

#new window

#newsletter

#not empty

#notification

#number field

#number of records per page

#number separator

#numbered column

#offer

#offline

#operand

#page break

#partnership form

#password

#payment

#pdf

#phone number

#plan

#popup

#portal

#position

#print

#quotation tool

#radio button

#records

#redirect

#referral program

#registration

#regular expressions

#relationship

#remind

#remove

#rename

#report

#rules

#script

#scroll

#search

#security data

#security menu

#server

#service

#sheets

#show/hide

#side by side

#signature

#size

#sort

#special character

#state

#storage

#subscribe

#suggestion

#support

#table

#team

#template

#text

#text direction

#time

#total

#trial

#tutorial

#two-column

#update column

#update records

#updates

#upload file

#users

#validation

#video

#view

#widget

#window

#wysiwyg

#youtube

#zip code