How can I inherit on table application to the other

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.

How can I inherit on table application to the other

Postby sagmag » Sat Jan 13, 2018 7:16 pm

I have 3 views from database and the different between their database is defined by the value of 1 column

View1 = SELECT * from table1 where catogorie='popo';
View2 = SELECT * from table1 where catogorie='huhu';
Vie3 = SELECT * from table1 where catogorie='kako';

the thing is for each of these view I have to make on application (Master-Details) because their details applications are different from one another
view1details = Select * from details1 ;
view2details =select * from details2;
and view3 doesn't have

So observing these my master views all of them have the same fields and same fields configuration but different applications.
Is there away I can set up view1 and make view2 and view3 inherit the field configurations from view1?
sagmag
 
Posts: 46
Joined: Tue Jul 18, 2017 1:15 pm

Re: How can I inherit on table application to the other

Postby Webmaster » Mon Jan 15, 2018 9:59 am

A simpler solution is to enable User ID Security (on the categorie field) so that users logging in with categorie='popo' with see only data from View1. You can then just use table1 as the master table for your application.
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (PHPMaker)