Set Master Details Relation FOR THE SAME TABLE October 02, 2019, 09:25:21 PM When you setup a Master Table: employees with Master Table Foreign Key: manager_id Detail Table : employees with Detail Table Primary Key: employee_idIt' s impossible to have Record Display Value Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #1 – October 03, 2019, 11:56:32 AM @orimix yes it is possible. Check image below. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #2 – April 14, 2020, 07:12:29 PM @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. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #3 – April 15, 2020, 08:10:12 AM @barakak can provide a screenshot of the error? Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #4 – April 15, 2020, 03:44:51 PM attached is the error message Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #5 – April 15, 2020, 07:07:58 PM @barakak Why are you doing master-details to the same table in different fields? Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #6 – April 16, 2020, 05:29:28 AM Quote from: willvin – April 15, 2020, 07:07:58 PM@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. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #7 – April 16, 2020, 11:21:23 AM @barakak please provide a sample project. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #8 – April 16, 2020, 12:40:02 PM Quote from: willvin – April 16, 2020, 11:21:23 AM@barakak please provide a sample project.Noted, I will. Any update on form Wizard... Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #9 – April 16, 2020, 03:28:35 PM find attached, kindly also check the sorting issue when ajaxpage=true Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #10 – April 17, 2020, 07:21:00 PM @barakak Sorting is working from my end with ajaxpage=true. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #11 – April 17, 2020, 07:59:02 PM Quote from: willvin – April 17, 2020, 07:21:00 PM@barakak Sorting is working from my end with ajaxpage=true.ok, is there any other setting, could you set it on the project that i shared and upload it, kindly. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #12 – April 22, 2020, 08:20:06 AM i've the same error on Record Display Field, it automatically add table name in front of field name, Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #13 – April 22, 2020, 05:52:45 PM @heri.pmck please provide a screenshot of your list page fields. Quote Selected
Re: Set Master Details Relation FOR THE SAME TABLE Reply #14 – April 24, 2020, 03:23:13 AM @willvin i've try to delete site folder at htdocs and republish, and its work with the same master and detail setting.thank you Quote Selected