relationship

[afawkes2001]

I have two tables that I have created a relationship for customers and transactions. I want to put them into a new single table a customer with all their transactons as new rows. Any ideas on how to do this. I have managed to get the relationship to work but not sure of how to write the loop.

If anyone can help It would really be appreciated

Thanks in advanced

ant

 

[ramani]

SELECT a.*, b.* FROM transactions a, customer b ;
WHERE a.customerid = b.customerid ;
INTO DBF myNewTable

Then open the myNewTable AND INDEX THEM SUITABLY

Hope this helps. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK