AppGini Community Forums

Greetings Guys,

I was told that possibly thru hooks I could achieve what I am working on. I am new to the whole program and not a coder by any means but have my database down to the last little "hard coding" that AppGini cant do.

I am looking to take the registered "user" and tie them into an employee record that echos their company information in place of it. I created a table called "security_officers" and inside it I have multiple fields however I am only wanting to echo in place of the registered "user" the: "officers_name" and "badge_number". I will have it echo in the other tables as a lookup field or so I had planned out. A friend that turned me on to this program mentioned I might be able to do this if I added a field in the "security_officers" table called "username" and put in the registered "users logon" in that field.

Please help, maybe there is any easier way to do this?

Thank You!

Where are the "officers_name" and "badge_number" stored?

In the security officers table.

Okay ... so, if I understand correctly, each officer would have a username that he can use to access the application. So you want to link each record in the officers table to a user, in a one-to-one relationship, right?

Yes so user submissions cant be altered.
ie:
user: jd135
badge: 100
name: john davis
reported as: john davis - 100 on records.

Hmm ... you could add a field for storing the username in AppGini, and set its default to the "Created by username" automatic value and also set it as unique ... this will effectively limit each user to a single record in the officers table.