Use just one relationship instead of two, then set up a portal filter that filters by male, female or all. You can have three different portals or a single portal with a field where you select the options you want for the portal.
The AND should be a OR but I don't know how to get that to work.
PhilModJunk Can you give me a hint how to filter this list?
(don't mind the gender it's all about the name)
You really shouldn't match by names at all. Names are not unique in most cases (Maybe they are here if this is registered animals), are subject to change and vulernable to data entry errors. An internally generated serial number ID is much safer for your relationships.
Sticking to one issue at a time, I'll use a name field for this example, but an ID number would be better:
Use this relationship:
Table1::Name = Offspring::Name
This will match a given record to all Offspring records with the same name. Then you set up portal filter expressions on your portals to limit the records to just "Father" or "Mother".
Thanks but I don't think I made it clear enough since it is not the solution for what I'm looking for.
Let me try to explain:
When I create a new record I define if it's male or female. Then I have (global M and global F) two gender value lists Father and Mother (all populated from the same table)
Splitting that and seeing the offspring of the father or the mother is not a problem but when I want to see the offspring (related to name) I can't seem to get that working since that is related to the father or the mother field.
If I try the option you suggest I only get the same value in the name field (my previous screendump is name X name with no filter) and I would only like to see what is related to the name (regarding) being the father or the mother.
Please have a look at the file maybe it makes more sense.
Better yet, please explain the function of Table 1.
I thought I did, but let me try again.
It is like a pedigree.
When a name is in the db and you select a father or mother I would like to see the offspring when you come to that record of the father or mother.
I need to define the gender (M or F) to make sure only Male appear in the valuelist Father etc..
I put it all in one table since it is the same entity.
The relation "OFFSPRING FATHER MOTHER" should be like this, only without X and based on how many records contain the name refferd to the parent.