lefty 1/16/2017 | |
Hi All, Has anybody experience this situation where we create a new invoice with invoice header and invoice lines (2 different tables) but when we go back to the list option we cannot see the entries. The entries are in the database but are not being listed for some reason. WE are currently using PHPRunner 8.1 with a MYSQL database. There are some entries that are listed showing the header and the individual lines but it seems those we have created are not showing up in the list option and therefore we cannot edit them as we cannot see them. Any help or suggestions will be appreciated Best Regards, Peterp
|
P
|
peterp author 1/16/2017 |
Sounds like a security issue to me . How do you have security setup . Static or Dynamic permissions. Check security on the table that is in question. users can see only their data option / etc....
|
admin 1/17/2017 | |
If your SQL query uses INNER JOIN make sure that you add matching records to both tables. Otherwise your query won't return any data. |
P
|
peterp author 1/18/2017 |
If your SQL query uses INNER JOIN make sure that you add matching records to both tables. Otherwise your query won't return any data.
|