Hello,

I'm working in a database I just created that has 4 tables: Employee, Managers, Departments, and Office Locations. This is my issue:

- I create a new employee record

- This employee is also a manager

- I would like to have a button that will create a manager record with the same Last name and First name as the employee I'm entering

Is this possible?

I came up with something close but its not quite there:

If (Manager? = Yes)

Go to Layout (Manager Form)

New Record/Request

Set Field (Empl: LastName; Mang: LastName)

Set Field (Empl: FirstName; Mang: FirstName)

Go to Layout (Original)

Else

End if

I know I get mixed up somewhere on the Set field part. Unfortunately, I'm not that experienced with scripts & calcs yet.

Please help!

I would like to have a button that will create a manager record with the same Last name and First name as the employee I'm entering

I believe this is unnecessary. Both Employee and Manager has Last Name, First Name, Social Security, Birthdate and the list goes on. They are the SAME entity and should reside within the same table.

You can instead have a field called Manager. And, if you decide that an Employee is also a manager then have field called Manager which holds the Manager's Title. Then you would have a ManagerID field which would hold their manager's employeeID. There is no need for redundant data at all. :wink2:

Edited April 8, 200916 yr by Guest
Reworded a bit

I agree with LaRetta here. Having these are two separate tables do not make sense. You may want to take a look at the links in this thread.

http://fmforums.com/forum/showtopic.php?tid/194038#285071