how to link field in table that are not the same? newbie

[#1]

Dear All,

sorry for newbie question, but tried to search how to do that with no luck.

I need to create a link between these to table values. I know how to use "AS" command, but when data differs i dont find solution.

thanks.

[MK_QSL · Accepted solution]

For the table which contains origin....

Remove origin as a field name and use below expression instead...

subfield(origin,',',2) as purchase_line_origin

[#3]

thank you! works brilliant.

[#4]

Guys, one more interesting thing.

I would like to use conditional conection of data:

Field Origin:

Sometimes it is refering to Stock.Move(table), 1 (value), sometimes to trytonlt_anglosaxon.line_move(table), 1 (value). I would like to connect these values and to reach the value in other tables. For example: If Origin is "stock.move,1" i want to connect to 1 value in Stock Move table, if it is "trytonlt_anglosaxon.line_move,1" I want to connect other table with it's value 1.

Earlier I was using

subfield(origin,',',2) as [stock.move_value]

and it working great, but only with one type of data. Any ideas?