I'm making a database that is used to keep track of software keys for users. I made a user table and a table for each type of software. They are connected with a user name field which is the primary key for the user table. I want to make a form that shows a user name and all the software that they currently have so when we re-image computers we can see all the software they use in one spot. However when I use the wizard to make the form and add the user name and all the software fields the form comes up blank. Is there some settings that I need to change?
I also tried doing this with a query and making a form from the query and noticed that I had to change the join properties to get the query to return any results. However when I do it this way if a user has more than one license key then they have a seperate form for each extra key they have. For example I made a user name called Open Acrobat Licenses and put all the open keys under this user. So now when going through the forms there are 50 some forms for the user Open Acrobat Licenses instead of just 1.
Any thoughts or help on my problem is appreciated. Thanks
I also tried doing this with a query and making a form from the query and noticed that I had to change the join properties to get the query to return any results. However when I do it this way if a user has more than one license key then they have a seperate form for each extra key they have. For example I made a user name called Open Acrobat Licenses and put all the open keys under this user. So now when going through the forms there are 50 some forms for the user Open Acrobat Licenses instead of just 1.
Any thoughts or help on my problem is appreciated. Thanks
