Show query in portal

[joki1975]

Hi.

I come from access and mysql, so this is mostly a general question.

I have a table with items. itermsid, name and partnumber. in another table i would like to show a portal with all iterms with itermsid over 10.

in sql:

select itermsid, partnumber, name

from iterms

where itermsid > 10;

how kan i do that in fm pro 6.

I miss all the function to extract data with parameters from the tabels, like i used to to do in mysql.

So please eksplain how i extract and show the data in fm pro 6

Thanks

[-Queue-]

Create a calculation field in items equal to itermsid > 10. Create a calculation field in your other table equal to 1. Create a relationship from the calculation 1 field to the iterms calculation field. A portal using this relationship will only show related records where the test calculation is true (itermsid > 10).

[joki1975]

Hi.

That a new way for me to think, but thansk for your help.