Numerous Many-to-Many tables and form

Visitor

I have created a new database with many-to-many relationships and I am having issues creating a form to track and enter data.

 

I have Users who may be assigned to different departments.

I have many users to a department.

I have many applications that may be assigned to users.

I want to see what departments have what applications associated with them.

 

I have created junction tables for UserApplications, UserDepartments, and ApplicationDepartment.

 

I have pre-populated a table with all Department Names.

I have pre-populated a table with all Application Names

I have added the Access_Date and Release_Date to the UserApplications Junction table to track when a user gets access to an application or loses access.

If I try to create a form to show all this information I get a blank screen. Need help in understanding where I've gone wrong.

 

Should I just create a table to show users with departments. A table to show Departments with Applications, and a table to show Users with Applications?

 

0 Replies