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

Replies
Jéssica Neves
Jéssica Neves
StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)StrataFrame Beginner (18 reputation)
Group: Forum Members
Posts: 14, Visits: 102


in fact it is so!

when the End User choose their field browserdialog

will enter the event

"SearchValueChanged"

then I want to make a variable to receive the Primary key field chosen by the User.

I'm not using combobox ...

sorry my english, I'm beginner.

Edited 15 Years Ago by Jéssica Neves
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
Jéssica Neves (10/25/2010)
in fact it is so!
when the End User choose their field browserdialog will enter the event "SearchValueChanged" then I want to make a variable to receive the Primary key field chosen by the User. 


Jessica, that is exactly what my code is doing, checking if the field that triggered the SearchValueChanged is "FK_Customers", then using the e.SourceControl you cast that to your control type and access the value you need from whatever property your control is using.

Now what do you want to do with this value?

sorry my english, I'm beginner.

Well it looks much better than my Portuguese Whistling

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