Hey Everyone, I was hoping y'all might be able to help me. I have a master employee table which has employee id number, last name, first name, login id, supervisor, unit, rank.
I have a form started, but basically I need it to be useable by the supervisors to add or remove people from their units, but I need to take into account that not all of them are tech savvy and I don't want them to be able to modify anything but the unit/supervisors in case that changes.
I tried searching the lessons/videos but wasn't finding what I needed. I could be using the wrong search times, but wanted to see if anyone might have some suggestions or an example for me to go off of.
I already have the form locked down so that only certain people can access it based on rank.
Thank you for any help you can provide.
Scott Axton
@Reply 3 years ago
Check out the Self Join Relationships. That video demonstrates relating family but could just as easily be employee an supervisor.
I can't see that you have been through any of the courses so don't know your experience level. This is a more advanced topic so you may need to start out with the Beginner 1 to not be way confused.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.