Please help simplify this form!

[kbrooks]

I posted this before with no response so I'm hoping this time someone can help me out.

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!

 

[Donna Tunstall]

This is where your Forms and SubForms come into into.

The Form (MainForm) would contain your "header" information - i.e. stuff that is common to all records, in this case User ID. The SubForm contains all the details pertaining to that user - applications and functions.

HTH