Home

Numerous Many-to-Many tables and form

%3CLINGO-SUB%20id%3D%22lingo-sub-719967%22%20slang%3D%22en-US%22%3ENumerous%20Many-to-Many%20tables%20and%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719967%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20new%20database%20with%20many-to-many%20relationships%20and%20I%20am%20having%20issues%20creating%20a%20form%20to%20track%20and%20enter%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Users%20who%20may%20be%20assigned%20to%20different%20departments.%3C%2FP%3E%3CP%3EI%20have%20many%20users%20to%20a%20department.%3C%2FP%3E%3CP%3EI%20have%20many%20applications%20that%20may%20be%20assigned%20to%20users.%3C%2FP%3E%3CP%3EI%20want%20to%20see%20what%20departments%20have%20what%20applications%20associated%20with%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20junction%20tables%20for%20UserApplications%2C%20UserDepartments%2C%20and%20ApplicationDepartment.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20pre-populated%20a%20table%20with%20all%20Department%20Names.%3C%2FP%3E%3CP%3EI%20have%20pre-populated%20a%20table%20with%20all%20Application%20Names%3C%2FP%3E%3CP%3EI%20have%20added%20the%20Access_Date%20and%20Release_Date%20to%20the%20UserApplications%20Junction%20table%20to%20track%20when%20a%20user%20gets%20access%20to%20an%20application%20or%20loses%20access.%3C%2FP%3E%3CP%3EIf%20I%20try%20to%20create%20a%20form%20to%20show%20all%20this%20information%20I%20get%20a%20blank%20screen.%20Need%20help%20in%20understanding%20where%20I've%20gone%20wrong.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShould%20I%20just%20create%20a%20table%20to%20show%20users%20with%20departments.%20A%20table%20to%20show%20Departments%20with%20Applications%2C%20and%20a%20table%20to%20show%20Users%20with%20Applications%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-719967%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
santaduffy66
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?

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies