High Level Description

At its simplest, I use Topics with Forms to mimic the operation of VlookUp with the FALSE parameter. So think of the Topic name as the first column into which you look and then the field in the form attached to the topic as the column which you want to return the value. Then you use %SEARCH% to do the basic looking up function and use the formatted output to return the $formfield() you want.

Example

VlookUp method:

	A	B	C	D
1	Code	Product	Price
2	A33	Lamb	15.00
3	B44	Pork	35.00
4	A67	Beef	175.00
5	C75	Torfu	23.50
6

So if A7 has the value B44, =VLOOKUP(A7,$A$2:$C$5,2,FALSE) will return Pork and so on....

This should be familiar! You can read more here.

Wiki Method

Example to follow!

-- NeilGood - 16 Mar 2009