Extract text from linked table
How do I extract and splice the record WEVBrandUID_0273 in the field WEV_Brand_UID in the table 'EVNews' from linked table 'EV Strategy' ? Thanks
5 replies
-
Cant you just use the 'Show as' function in options to extract the text you want?
-
Not sure how that will work. The source is a linked table, so all the fields are in one string. It would be interestng to see your proposal, can you give an example? thanks
-
1. So when i select a linked option via the search field, the full string of information is copied into the cell as shown....
2. however if i click on the field options and click 'more options' and click on the 'show as' field.....
3. then when in the editor i simply select the fields that i want to be displayed, in this instance a contacts 'First Name' and 'Suranme' spaced with " ".
it then only displays the infromation required from that string of infromation....
Hope you can make sense of this?
-
Awesome thanks that was a big help.
-
Glad to help, where I can and happy that you've found a solution :)
Content aside
- 4 yrs agoLast active
- 5Replies
- 910Views