Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




connecting two custom fields

custom-fields

Hi,

i have create two new custom fields. now i want to connect these two custom fields. like a relationship in a SQL Database. how can i do this?

best regards,

SMAD12
· 1
SMAD12
Replies (12)
helpful
0
not helpful

Yes, in Gemini 5.1.5 you can specify a custom field the is cascading. So you create the primary custom field, followed by the "child" custom field and specify in the child's definition that it is cascading from the primary one.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

i want to link the two custom fields. for example, i choose one option from the primary field. then the connected fields from the "child" field are available to use.


SMAD12
· 1
SMAD12
helpful
0
not helpful

Yes, that is what I explained above.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

it doesn´t work


SMAD12
· 1
SMAD12
helpful
0
not helpful

Care to be more specific? What did you do?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

first i have create two different tables in the sql database. then i creat the two custom fields. a primary and the "child", which is cascading from the primary one.


SMAD12
· 1
SMAD12
helpful
0
not helpful

Please send screenshots of the definitions to support@countersoft.com


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

i transmitted the screenshots to the support email. why can´t i choose not more than one option in the "child" field?


SMAD12
· 1
SMAD12
helpful
0
not helpful

From the screenshots it seems like your "child" table is wrong! you cannot use the same field as a foreign and primary key for the child table.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

how i have to change this that it works?


SMAD12
· 1
SMAD12
helpful
0
not helpful

Parent table will have severityid and desc and child table will have severityid, fieldid, desc


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

can you send me a screenshot of ths config? please


SMAD12
· 1
SMAD12