Re: Search...ing for the moon

> Each record has a number of fields in cluding three "sets" of fields relating
> to Child 1, DOB, Month (set 1),Child 2, DOB2, Month2 (set 2) etc.

Chris;

That's the problem, your structure is incorrect.

You should create another file called Children, related to Clients by
ClientID (a unique serial number assigned to each client). The children can
be viewed, created and edited in a portal.

Then it is a simple matter to search the Children file.

Mark
-- 
Mark Rubenstein
Easy As Pi
FileMaker 7 Certified Developer

email: mark-Gknh7RpVa+VWk0Htik3J/w@xxxxxxxxxxxxxxxx
phone: (847) 869-6020
fax:   (847) 864-4340
www:   www.easyaspi.com