0

Lookup, referencing.. Help!

Hi, I have 2 tables. Lets say Table A and Table B. I would like to call data from Table B to Table A, hence I get into table A and made a relationship to Table B... I do not click the relationship field to Table B to specify which row to choose from.

In table A, I have a text field "9" written on to it.. How can I lookup the ID number 9 from Table B to Table A?

I would like to lookup the row ID according to the text field..

Please someone help me, I am really stuck!

1 reply

null
    • Daniel_Berrow
    • 1 yr ago
    • Reported - view

    Hi Vinson,

    if you just want a specific record field/are using this in a formula for other information to be populated used 
     

    let t := this;
    record('Table B', t.number('text field'))

    This will return the record from the text value from Table B

    If you're trying to retrieve the whole record into a view, so you can display it then use the formula

    let t := this;
    select 'Table B'[number(id) = t.number('text field')] 

    Hope this helps!

Content aside

  • 1 yr agoLast active
  • 1Replies
  • 120Views
  • 2 Following