0

Choice Field Trigger

Hi to all!

I have got this structure:

MasterSearchTable - fields:

  1. Choice Dynamic
  2. MusicBrainz ID

MBIDsTable - fields:

  1. MBID
  2. Description

as you can see the Choice Dynamic field is correctly connected to the MBIDsTable .

i am setting top a trigger in the choice dynamic:

let xMBID := 'Choice (dynamic)';
'MusicBrainz ID' := xMBID

 

Copy

 

and this trigger return the ID of the record correctly.

 

The question is: how can I return the field MBID of the record and not the ID?

 

Thank you in advance
 

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr ago
    • Reported - view
    let xMBID := 'Choice (dynamic)';
    'MusicBrainz ID' := record(MBIDsTable,number(xMBID)).MBID
      • francescostefanello
      • 1 yr ago
      • Reported - view

       Excellent, thank you a lot

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 2Replies
  • 56Views
  • 2 Following