hello,
1 - i have restrict user access to INVOICE table with User can see and edit their own records only option on the Advanced security settings dialog on the Security tab and select company as OwnerID field in both tables.
2 - i have admin section custom view of INVOICE table on the Datasource tables tab for admin,
3 - i have admin and default accounts on the User group permissions dialog on the Security tab and setup required permissions for these two groups. Check off list, add and edit permissions for custom view of INVOICE table for admin account only.
IST THERE ANY CODE TO SHOW ONLY RECORDS OF ADMIN WHO IS CURENTLY LOGED IN (I HAVE FIELD IN TABLE admin name)
thanks