Hi guys,
hope someone here is able to offer some advice (and I posted this in the right forum).
Basically I have created a PO system that everyone at my company has thought 'ooo that's nice can we use it' it isn't anything special or earth shattering really.
However I am aware that in order for me to be able to roll this out to multiple users I need to be able to restrict the records being viewed based upon the user accessing the DB and the group they belong to.
So my question is this. Is there any way in FM 8.5 I can restrict the found records (and keep them restricted) that the currently logged in user can browse based upon their group or username. When a new PO is created I'm recording the user ID of the creator (their FM login) so I wouldn't have thought this to have been too difficult, however after some initial digging around I can't find any way to reference the current logged in user, let alone compare that against the users and groups defined within the DB (not as a separate table, but FM users and groups).
Hope that makes some semblance of sense and any help/advice would be greatly appreciated.
CB.