>I have one table from wich I want to combinate every possible combination between records. I am trying to do that for all the last week. Some idea? Thanks.
Depending on the way you organize the records, VFP can do that directly for you.
Suppose that I have a table "table_a" with a field named "value_a" and another table "table_b" with a field named "value_b". To obtain any possible combinations of the values of the 2 fields all I have to do is doing a select without "where" clause between both tables. If there is 10 diffenrent values in value_a and 100 values in value_b the result will be a table with 10*100 records. Be careful with this kind of select, the result can be really big if many records are selected!
SELECT value_a, value_b FROM table_a, table_b INTO CURSOR CombinedValues GROUP BY 1,2
HTH :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca