Makes perfect sense, but it's not necessarily easy to do. You'll need at least 4 tables: Employees, Clients, Projects (& possibly tasks ), and Tasks Performed. FM will automatically create a layout for each table. Most of these you'll want to hide from the regular employees, either through access privileges or unchecking the 'Include in layout menus'.
You'll then need to create the layout for the employees to use when entering tasks, and this is the tricky part. It's going to involve scripting, dynamic value lists, and the proper relationships. Feel up to the task?
Most definitely – I will do whatever you say… this will be great working this out.
I'm all ears!
Cool I have the 4 tables created and each has one field using the same name as the table
-Employee = filed Name
-Client = field client
-Project = field project
-Task Performes = field task
Did I do this right?
Sent you a pm with a link to a sample db.