I will read the link you posted and try to post my table relationships with some data. I see your point that I could drop the Applications from the profile table (which is a one-to-many relationship to the other tables), as long as I have the junction table there. I will also think about adding...
Thank you for the reply TheAceMan1. I will be working on it tomorrow and let you know how I do. Just a quick question though. If you don't use the multi-valued control, how would you do it? Would you set up a another table for the profiles?
I appreciate your time!
I would like to create a form that will have three different combo boxes. The use of this database is so we can make sure a when someone starts in a department they get all the right applications and profiles the day they start without having to ask the department each...
I created a form that contains a synchronized combo box (Access 2007), based on an example that Microsoft has and it works.
A user can Select Box 1 and in box 2 you'll only see the items that fall under that choice made in Box 1.
I am new to building advanced Forms so I don't know how to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.