User Account name determines what field information the user can see.
I don't even know where to start here!
I have attached our setup layout for a new hotel so you can see what fields we have available to do the script:
What Needs to happen:
The setup as you can see, determines the users log-in and password. (this is just a sample passwords are more rebust)
When this user logs in, I need for him/her to see only the hotel information they are assigned to.
Each hotel has to report labor figures on a weekly bases
I figure that I have to create a relationship that will tie the user to the hotel ID, can you help me get started..