Text only | Text with Images

PHPRad Classic Initial 2.7.3 Forum

PHPRad Forum => Issues => Topic started by: alkaf on July 28, 2022, 04:16:02 AM

Title: Error violation: 1052 Column 'no_pr' in where clause is ambiguous
Post by: alkaf on July 28, 2022, 04:16:02 AM
Hi, i want to ask how you can make the detail table display more than 1 record, because here i click on the no_pr, which only shows 1 data record in the detail table, while the value no_pr has 2 detailed data records. thanks

(https://ibb.co/Xz4VTCq)

my design is like this example:
master tables:
NoPR
00299

details table:
NoPR     Product
00299      A
00299      B
00299      C

this sample
(https://ibb.co/ypX1xjv)
Title: Re: Error violation: 1052 Column 'no_pr' in where clause is ambiguous
Post by: willvin on August 01, 2022, 03:33:59 PM
@alkaf‍ Set the master details relation for that field and use the list page. you ca watch the master details configuration tutorial here (12) Creating Master Detail Pages in PHPRad - YouTube (https://www.youtube.com/watch?v=Yx4tt6lk3wc)
Text only | Text with Images