Joined: 23 Jan 2013
Online Status: Offline
Posts: 1
Topic: Combine Fields for Link Posted: 23 Jan 2013 at 1:56pm
Anyone know if it is possible to combine fields to make a link to another table? For instance with Sage 100 (MAS200), the PO_ReceiptHistoryDetail contains 2 fields, ReceiptType and ReceiptNumber. So G is my type, then 000100.
I need a link for item landed cost, which is on the IM_ItemCost table, but it's field has them combined. G000100.
Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Posted: 23 Jan 2013 at 7:53pm
You can try making a text field and concatenate the 2 fields inside then format the field and use a formula like textfield=field from IM_ItemCost table where you use the name of the field in the table but you'll need the tables in your source links for it to have a chance to work.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 24 Jan 2013 at 3:51am
if you cannot use a stored proc as a source I would use a command object and concantenate the 2 fields in that where you could use it to join at the source level.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
