Hello,
creating a database where one would be able to look a user (using an username) and from there one could see the equipment that has been assigned to them (like monitor, pc, etc.).
But am having some trouble with the Form.
Currently I have created 4 Tables: Users, Monitors, PCs, Extra (eg. mouse, keyboards). Have then defined the Relationship through Username in the Tables (each table has a username field). The Relationship is then set up for '1-to-many' with username in Users being Primary key and short-text, and the rest just short-text.
I can then create a Form with data from 2 tables (eg. Users and PCs). And then have PCs as an underform to Users. From there and can search for any username in Users table and if they are also written in the Username field in under PCs it will show which PC are asigned to them. And if none are asigned it will leave it blank.
But I would like to have 1 Form with then multiple underforms (PCs, monitor, etc). Where it would then for each user display if they have a that equipment. And if not, leave it blank.
But when I tried to add the monitor to the Form as an underform. The it would continue to show data, even if the user didn't have any.
Also tried to create a Form, with adding data from all the tables. But then it would only show the users who where written into all the tables.
Am I missing something in the creation of the Form? Should I maybe make use of Queries? Or is there maybe something with the Relationship of the tables?
creating a database where one would be able to look a user (using an username) and from there one could see the equipment that has been assigned to them (like monitor, pc, etc.).
But am having some trouble with the Form.
Currently I have created 4 Tables: Users, Monitors, PCs, Extra (eg. mouse, keyboards). Have then defined the Relationship through Username in the Tables (each table has a username field). The Relationship is then set up for '1-to-many' with username in Users being Primary key and short-text, and the rest just short-text.
I can then create a Form with data from 2 tables (eg. Users and PCs). And then have PCs as an underform to Users. From there and can search for any username in Users table and if they are also written in the Username field in under PCs it will show which PC are asigned to them. And if none are asigned it will leave it blank.
But I would like to have 1 Form with then multiple underforms (PCs, monitor, etc). Where it would then for each user display if they have a that equipment. And if not, leave it blank.
But when I tried to add the monitor to the Form as an underform. The it would continue to show data, even if the user didn't have any.
Also tried to create a Form, with adding data from all the tables. But then it would only show the users who where written into all the tables.
Am I missing something in the creation of the Form? Should I maybe make use of Queries? Or is there maybe something with the Relationship of the tables?