Im trying to create a simple database for the my primary school.
It is for logging the information from each PC eg serial numbers, what printers it has etc, and also what software titles have been installed.
When i try and create a form i cannot get it to display correctly, i want a form with all the pcs details, and a sub form with all the software installed on that pc, is that possible?
I have attached a pic with my fields etc displayed in two tables, COMPUTERS and SOFTWARE - i think the problem is connecting these two tables, what relation ship etc??
Bellow is a pic of the form, i have entered some software titles in the software table, but none show in the form, how do i link a piece of software to a PC? software is installed on some pcs but not on others! help!