This should be possible but would require at least the Enterprise or Corporate Editions.
Firstly, you would need to add your own 'user' column to the find/look-up window. The topic: "Stock Find User Column Hook (R-SFColn.MAC)" explains how to do this.
Secondly, you would need to open the second stock file within the column. You can use the OpenTable() function to do this (consult the Visual Builder help file) but you would need to specify both a path and an alias, i.e.,
OpenTable(PathData() + "Company2\Stock.dbf", "Stock2")
Then use Find() to locate what you are after, i.e.,
Last edited by COBS Tech Support
on Thu Mar 13, 2008 7:57 pm, edited 1 time in total.