i have created a Master-Detail using 1 view (Master) and 1 table (Detail), both have same column (customer_id) but not primary / foreign key relationship, created relationship with that field. IG is not Editable, just like a Report.
when both are hidden, then showing data in Master & Detail normally, but when changed type to Select List in Master now it is not showing Detail data, also tried Select List for same column in Detail but failed, still not showing detailed data.
what is the solution to have working Master-Detail with 1 view and 1 table with No Primary & Foreign key relationship but have same column in both db objects? and at least Master customer_id column should be a Select List type.