Skip to main content
Topic: Set Master Details Relation FOR THE SAME TABLE (Read 2546 times) previous topic - next topic

Set Master Details Relation FOR THE SAME TABLE

When you setup a
Master Table: employees with Master Table Foreign Key: manager_id 
Detail Table : employees with Detail Table Primary Key: employee_id

It' s impossible to have Record Display Value


Re: Set Master Details Relation FOR THE SAME TABLE

Reply #2
@willvin  when you set Master relation for same table in different fields it brings alias error. it was working with version 2.7.2 however.


Re: Set Master Details Relation FOR THE SAME TABLE

Reply #4
attached is the error message


Re: Set Master Details Relation FOR THE SAME TABLE

Reply #6
@barakak‍ Why are you doing master-details to the same table in different fields?

It's basically a master table that I use for static data each with its own unique number, and I use the static data in other foreign key tables.



Re: Set Master Details Relation FOR THE SAME TABLE

Reply #9
find attached, kindly also check the sorting issue when ajaxpage=true



Re: Set Master Details Relation FOR THE SAME TABLE

Reply #12
i've the same error on Record Display Field, it automatically add table name in front of field name,



 

Re: Set Master Details Relation FOR THE SAME TABLE

Reply #14
@willvin i've try to delete site folder at htdocs and republish, and its work with the same master and detail setting.

thank you