filtering portal based on non global field

[Nemo]

I've went through and read all the posts i could find relating to portal sorting/filtering but i am still am having an issue.

The issue being:

I have a portal wich displays all the records in my "contractor" table. I have another table "FP" wich has info regarding our jobs.

These two tables are related by a field called "recordID" in each respectivly.

There are mutltiple "contractor" records, for every one "FP" record. The "Contractor" records that correspond to the "FP" record share the same "recordID".

I need the portal to display only the records

that have a "recordID" that corresponds to the "FP" record Im on.

Sorry if this sounds a bit convaluted, but this has had me stumped.

[Søren Dyhr]

Might it be because you mix up tables and table occurences??

Just relate the main TO with an extra TO of your childrecords, with the required field.

--sd