hi all,
i have an algorithm problem which needs input from you guys, any help would be greatly appreciated!
suppose i have table1 to hold inventory items (finished products). and table2 to hold items (finished, semi-finished, raw materials) in relation to items in table1. as in this figure:

table1 table2 table2
------ ------ ------
item1 ----> item1.1
item1.2 ----> item1.2.1
item1.3

item2 ----> item2.1
item2.2
item2.3

wherein item1 is a finished product, which consists of item1.1 (raw material), item1.2 (semi-finished product) and item1.3 (raw material). since item1.2 is a semi-finished product, i have to look for its pre-defined details (like i did for item1) in table 2 also (which is item1.2.1, a raw material).

im thinking of having a recursive function but does vfp allow this? if so, how would i do it?