AnsweredAssumed Answered

How to have a log-in dependent layout?

Question asked by jdevans on Nov 4, 2014
Latest reply on Nov 4, 2014 by jdevans


How to have a log-in dependent layout?


I am trying to create a system to track employee training.

I have an employee table (employeeID_pk)

I have a training item table (trainingItemID_pk)

I have a training occurrence table (trainingOccID_pk, trainingItemID_fk, employeeID_fk)

The training occurrence table is a "line-item" table basically. 

What I'd like to do is, upon opening the database, the user logs in with username/pw. After logging in, if they open the "Training Occurrence" layout, which enables them to add a new training item, or update an existing record, I only want to display THEIR records. The Training Occurrence Table is gathering data from all employees, but I only want to show a particular employees' records to them, A) for privacy, and B) to prevent tampering.

Anyone ever done anything like this.> BTW, I could use this same methodology (if it can be done) on a timesheet layout.

I just can't seem to formulate an idea on how to solve this one. Thanks in advanced...


a NOVICE FileMaker