Portal filtering

[reynir]

Hi

I have a problem filtering portal.

My database is used to manage quality control records for products.

The tables involved are:

Products:

Fields: Product_ID, Product_Name, Product_Number, Product_type, fk_Species_ID

Species:

Fields: Species_ID, Species_Name, Species_Latin_Name

Seven different QC records tables:

Fields: QC_record_ID, fk_Product_ID

Like: One for fresh tomatoes, one for frozen tomatoes and one for canned tomatoes.

The problem is that the qc_records are different for some species but others can have more than one species (Hope you understand my structure :-)

What I am trying to do is making a relationship to each type of qc records. And then to filter each portal based on Product_Number.

I have managed to make the relationship show all records from each qc records (I used auto enter constant in each table).

I have not managed to make the relationship right to filter the portal based on each Product_Number.

Any help appreciated.

Regards,

Reynir.