kbrooks
Still learning
- Local time
- Today, 05:38
- Joined
- May 15, 2001
- Messages
- 202
I have a database set up to capture the applications and functions each user has access to, for security reasons. I have 4 tables...
1. The user table lists user id, user name and user department.
2. The application table lists each application id and application name.
3. The function table lists each function id, what application id it belongs under, and a function name.
4. The fourth table is where I'm storing a combination of the above 3 to show what they have access to. Each record lists a user id, application id, and function id.
The form I have right has only 3 blanks and I need to enter user id, application id and function id on every single thing they have access to. I'm sure there's a way to simplify this to avoid rekeying the same user id 100 times, but I can't wrap my brain around it.
Is there a way to make a form where I enter the user id only once, and then enter each application id and function id? I'd still want only 1 per record, I think.
Thanks!
1. The user table lists user id, user name and user department.
2. The application table lists each application id and application name.
3. The function table lists each function id, what application id it belongs under, and a function name.
4. The fourth table is where I'm storing a combination of the above 3 to show what they have access to. Each record lists a user id, application id, and function id.
The form I have right has only 3 blanks and I need to enter user id, application id and function id on every single thing they have access to. I'm sure there's a way to simplify this to avoid rekeying the same user id 100 times, but I can't wrap my brain around it.
Is there a way to make a form where I enter the user id only once, and then enter each application id and function id? I'd still want only 1 per record, I think.
Thanks!
