Providing for multiple dates for a users access

[duffyt]

I want to track users access to an application. I have a table for the user, a table for the application, a table for the dates and a connection table.



The user table contains a User_ID (Auto Number) and User_Name field.

The Application table contains a App_ID (Auto Number) and an Application_Name field.

The App_Date table contains a Date_ID (Auto Number), an Access_Date, and a Remove_Date field.

The Connection table contains an Lookup Field for the Date_ID, App_ID, and User_ID Auto Number fields in each of the other tables.

A user can have access to multiple applications.

A user can access date can be multiple (access granted one date, then removed another date and then access granted again a later date)

A user can have multiple access remove dates.

What would be the best way to create a form to account for the user to show multiple applications and track multiple access/removal dates for the user? Or would it be best to have two forms, one to show all applications a users has access to and then a second form to show dates the users was granted/removed access to an application?

Thanks in advance.

[rpeare]

If you're using unbound forms you can do this all with code.

If you're doing this with bound forms have a main form relating to the user.

I would tend to make this a tabbed control (depending on how many fields you have) with two subforms.

one for their access to applications
one for their connection to said applications

In either case, you could then see all information relating to a specific person in a single form.

[duffyt]

Thank you for your response.

If you're using unbound forms you can do this all with code.

If you're doing this with bound forms have a main form relating to the user.

I would tend to make this a tabbed control (depending on how many fields you have) with two subforms.

one for their access to applications
one for their connection to said applications

In either case, you could then see all information relating to a specific person in a single form.