Master with Multiple Detail August 21, 2021, 02:35:39 PM hii,i trying to make a simple Job database with job table as master and multiple detail such as, receive, quote, delivery etc as detail. shown at job list page,the problem is, when i delete one of record of the detail table, such as P0002.the list page not shown Job record J0001 anymore even the record still on the job table.please see image job list page - job id not shown.jpghow to make all master record shown when some of detail record are deleted.Thank You Quote Selected
Re: Master with Multiple Detail Reply #1 – August 21, 2021, 10:01:44 PM @heri.pmck you will have to write your query in action after delete to delete the matching record from the other table. Quote Selected
Re: Master with Multiple Detail Reply #2 – August 22, 2021, 07:10:03 AM thank for your kind reply,i attached gif file that shown how a JOB record not shown when a PO record add and deleted. Quote Selected Last Edit: August 22, 2021, 07:13:59 AM by heri.pmck
Re: Master with Multiple Detail Reply #3 – August 24, 2021, 03:15:10 PM @heri.pmck if you configured the join statement on that page, that will be what is causing the error. remove the join statement and it should work. Quote Selected
Topic: Master with Multiple Detail (Read 1460 times)
previous topic - next topic
Track issues, Ask questions, Make suggestions,Report a bug