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

Por

Phil

on 23/12/19, 10:04 • 1599 visualizações

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

Responder
Comentário
Partilhar

João Ferro

Ligar 23/12/19, 10:16

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.

Comentário
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: 23/12/19, 10:04
Seen: 1599 times
Last updated: 23/12/19, 10:16