AnsweredAssumed Answered

Constrained finds using different layouts

Question asked by aikiko on Mar 30, 2011
Latest reply on Sep 5, 2011 by aikiko

Title

Constrained finds using different layouts

Post

Dear All,

I am a newbie and have a tricky 3 "stage" find question

I have 2 layouts: layout A which is a census and layout B which is a detailed household survey. These 2 layouts represent different tables which are linked by ID numbers of individuals.

I search for the number of "women"in layout A.

Out of these "women" in layout A, I want to find how many children does this woman live with. This listing of children is in layout B. nb: the mother is linked to the child via a "household number".

Then I want to find the list of all these "children".

I can do a constrained find, but only in the same layout, but not when I change layouts.

Any assistance will be of tremendous help for my health survey.

Thank you very much in advance.

Aikiko

FMP 10Adv

Mac OSX

Outcomes