[SOLVED]  Concatenating Fields

This topic is locked

[SOLVED] Concatenating Fields	7/12/2013 3:37:23 PM
PHPRunner General questions
R rgfischerjr author Table structure includes: tblItem: idItem, ItemDescription, idMfg, MfgItemNo, ... tblMfg: idMfg, MfgName,... (thought about using MfgName as a natural key but opted not to since I don't know what changes may come in the future) tblVendor: idVendor,... tblVendor_Item: idVendor_Item, idItem, VendorItemNo,... When adding or editing tblVendor_Item, I would like to be able show the item Description as "ItemDescription + MfgName + MfgItemNo" in a drop down to ensure the correct item is being linked to the vendor (multiple items,i.e. ItemDescription, are manufactured by multiple vendors) How can I concatenate the fields from two different tables? Thanks!


	Sergey Kornilov admin 7/12/2013
	Create a 'Custom View' in PHPRunner that pulls data from several linked tables. Use this Custom View as a datasource for your lookup wizard.