On my database I have 2 table:
First table is ‘affecation’ : have 2 columns ‘code’ and ‘description’
Second table is ‘service’: have 3 columns the first is ‘id’ is autoincrment field and the second ‘description’ and the third ‘affectation’ wich was a foreign key from table ‘affectation’.
Now in phpmaker 2020 the column ‘affectation’ for table ‘service’ is a select and use lookup table with table name ‘affectation’ and link field ‘code’ and display field1 ‘description’.
But when i generate there is no data my select field that normaly should fillled by list of description data knowing first that the table ‘affectation’ have data inside.
I didn’t understand where is my fault.
If there is someone can help me please!
Thanks
Did you use “Dynamic User Level Security” (please read “Tutorial - Advanced Security - Dynamic User Level Security” topic from PHPMaker Help menu for more info)?
If so, make sure you have already given “Lookup” permission for the “affectation” table from the generated userpriv.php page, and then try again.