Select record in a relational field

Hi Max,

you can select fields in related table with the select command. Please see the function and language reference.

Or visit one of our webinars:

https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg

Best, Alex

Hi Max,

We would like to understand your enquiry better. If I understand you right you want to assign every data record that contains the text "Group2" (among other text) in the field Group to the table Group as "Group 2". But what about the text "Group1" in your field Group? As I can see it you can only assign one group in the connection field Group2. 

Could you please explain your issue a little bit more detailed? How ist your datamodel?

I think as well it would be the best if you could join our webinar tomorrow evening (or another tuesday - please register via the link in the post above). That would surely help us to give you a better support.

Thank you very much for your cooperation.

Best, Jörg

Hi Max,

I will send you back your "Test" database via e-mail. I made you an automatic connection for your "copy" table, but it will only work if you have only one group assigned in your "Group" field as is can only be connected with one record of your "Group" table. I can still not really understand what the purpose of the tables in your database is, but I hope I could help you with the trigger for that connection.

Ciao, Jörg

Hi Max,

check out how to select values with a filter. Filters are applied in square brackets []

If you like, join our webinar and we can help you out.

It is a bit hard to understand your specific use case without additional information.

Best regards, Alex

That means that you are truly amazing because without understand you solved my problem

many thanks