Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

Hide Intro Register

Conditions for table based on other table that has foreign key to first table

Phil

on 12/23/19, 10:04 AM • 1,545 views

If you need to set a condition (for example, background color in a list) based on if a row's primary key is the foreign key of a row in another table, how can this be done in Genio?

So, if table A has any rows with a foreign key having a value of the primary key of row X in table B, we set the background color of row X in table B.

Flag

Reply
Comment
Share

João Ferro

On 12/23/19, 10:16 AM

Hi Phil,

If I understood the problem correctly, I think one way to achieve what you want is to use a related sum (SR) to count the number of A records in B, and use that field in the background condition of your list.

Comment
Flag

Ask a Question

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

15 follower(s)

Stats

Asked: 12/23/19, 10:04 AM
Seen: 1545 times
Last updated: 12/23/19, 10:16 AM