Sorry for this question!!!

[soriano]

Hi again...

I have my DB with many relations and I want to create another but I can't, please help me.

OK, I think may be it's easy, I have MY DB (Patients) and another 2 DB (CXCOP and CXCOR) when I create a payment in my Patients DB create a record in some related DB, (depends the patient status), but I want to find to all family in my report and show me the total by family in my Patients DB.

Can I do this with the mother name field??, for example:

Mother's Name: Karol Scultz

and show all her sons may be 2, 3 etc. and the Total to pay for all her childs.

The mother's name field is in the Patients DB, please help me to do this, TKS

Jorge Soriano

[Kurt Knippel]

Names are almost always a BAD way to make relationships. Too many people have the same names.

A better idea is to have a unique ID field for each record. See my article for information on this topic: http://www.fmforums.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=8;t=000018;p=

Then you can simply relate each of the other records to thier parent record via this ID field.