0

Select record in a relational field

Hi, I would like to know if it's possible to select a record in a relational field by a text field value.

Thanks in advance

Max

8 replies

null
    • Support
    • 6 yrs ago
    • Reported - view

    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

    • maxvalentino
    • 6 yrs ago
    • Reported - view

    Schermata 2018-07-19 alle 14.50.42

    Hi Alex, my question is about this small problem I have.

    A text field (Group) that contains one record (Group 2,Group 1) and a relational field (Group2) that is linked with a table that contains several records, one of them surely is Group 2,Group 1.

    What I would like to do is an automatic selection of that record in Group2.

    Thanks

    Max

    • Support
    • 6 yrs ago
    • Reported - view

    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

    • maxvalentino
    • 6 yrs ago
    • Reported - view

    Hi Jörg,

    Find here the link at the datamodel, as it is I would like in the table Copies an automatic selection of the proper record  in the "Group2" connection field for the "Group" text field value.

    https://www.dropbox.com/s/uesvklf9pra246m/Test.ninox?dl=0

    I hope you find it useful.

    Ciao.

    Max

    • Support
    • 6 yrs ago
    • Reported - view

    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

    • maxvalentino
    • 6 yrs ago
    • Reported - view

    Many thanks Jörg,

    Explain the purpose of my request is a bit difficult but I'll try.

    I have a table that create several records per supplier, some of these are sent to another table by a button.

    My need is to trace these records and the related values added in the destination table.

    I hope it wil clarify a bit.

    Ciao

    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view

    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

    • valentino_max
    • 6 yrs ago
    • Reported - view

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

    many thanks

Content aside

  • 6 yrs agoLast active
  • 8Replies
  • 4153Views