view details from table on front end

[Ramli]

Hi,
I have created a search filter to output a table. To view detail there's a link on the name of the person.

The output from the fields that are join from another table gives the primary key and not the value.

The fields are year, session, course, state and country.

The url is http://aku.gotdns.org

I am using fabrik 1.0.3

Thanks
rosslee

[Ramli]

hi,
I have tried this on fabrik2.0a and seems OK. It displayed the value.
Being new to fabrik, I prefer to use 1.0.3 but somehow this issue made me undecided to commit to which version of fabrik.
This 2.0a seems Ok so far.
If there is a slightly better version I would like to know, please.

Thanks
rosslee

[hk2n]

Hi

There is a workaround for the problem.....may not be the best, but it works
When you create the database join element, for the Foreign Key column, select the column which has the value instead of the foriegn key ...

I am currently using 1.0.4b (with the patch). Its a beta, but quite stable

Regards
Hani