Table where primary key is also foreign key


Author
Message
Marcel Heitlager
Marcel Heitlager
StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)StrataFrame User (274 reputation)
Group: StrataFrame Users
Posts: 84, Visits: 835
Any recommendations on how to deal with the following scenario (this is a representation of what I'm trying to accomplish)?

A supervisor is an employee and an employee can be a supervisor.  Also certain employees can work under certain supervisors. All employees have a supervisor. So you would have a table that might look like this:

employeeKey  last_name  supervisorKey
1                  smith        1
2                  johnson     1
3                  smithers    1
4                  chase       4
5                  baker        4
6                  brown       1

If supervisor key = employeekey then the employee is the supervisor.

How would you handle it when, for example, you are entering new employees and supervisors on a grid, on an autoincrementing table (like vfp - which I got to work with your Bo's) and you do a batch save?  I would need to know the employeeKey in order to apply a value to supervisorKey. Can this be handled with one business object, or would it be best to just create two business objects one for employees, one for supervisors and save the supervisorsBO first, pull the employeekeys, apply them to supervisor key in employeeBO and then save employeesBO to same table?

I've been racking my brains about this.  Thanks in advance for any input.

Marcel

Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Sorry but I don't read/speak Portuguese Hehe  I truly love the language, know some music artist from Brazil,  very well known here in America like Nelson Ned, Alexander Pirex, Roberto Carlos and of course the must famous one, the SF Googleish Ivan Tongue

Please, post in English so I can follow.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search