Skip to Content
0
Former Member
Apr 22, 2009 at 09:32 AM

Formatted search problem

16 Views

Hi,

i've a problema with a formatted search:

i want to create a serial number's substring to copy in a user Field.

i want to launch this query automatically, and i want to update this user field when the user create serial numbers, without the user launch this query.

this is my query:

SELECT DISTINCT SUBSTRING (T0.[IntrSerial], 11,9) FROM OSRI T0 INNER JOIN SRI1 T1 ON T0.SysSerial = T1.SysSerial WHERE T0.[ItemCode] = 'ST_2400_4X2_SL' and T0.[IntrSerial] = $[$3.54.0]

Anyone can help? thanks a lot