Change foreign key display to field other than ID.

October 11, 2022, 10:06:06 AM

Hello
I am currently evaluating PHPRad for a project.

I'm wondering how can I display in a table a different value than ID of referenced foreign keys.

In the "Add Page" Settings for a Field Datasource I can select the "Value Field" which is the Foreign Key and I can select the "Label field" that is displayed when inserting a new record.

I can't figure out how to do this for the "List Page".

Re: Change foreign key display to field other than ID.

Reply #1 – October 11, 2022, 05:08:07 PM

@michael724‍ you can use join configuration or master details to display the records. https://www.youtube.com/watch?v=Yx4tt6lk3wc https://www.youtube.com/watch?v=1ZZZY5XSWDo&t=91s