Skip to main content ↑ ↓
Topic: Set Master Details Relation FOR THE SAME TABLE (Read 2594 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 –
Quote from: willvin –
@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