Hello, my name is Jonah, and I am attempting to make a database of teaching materials.
We have some material that can be used in more than one class, and I would like to make it so you can search for the class and find the material needed, these are physical items, i have pictures in the database, and i have their location listed with what room they are in, then which cupboard and then which shelf. The search function is made and works, its a simple Me.Filter code in VBA.
To start I have made a Tabel with some basic information about the item, including the class numbers it applies to, which is linked to a table including the class numbers and names to make it easier in the forms.
What I would like to be able to do is add more classes per item. Eg: if the teaching material is applicable in classes 1.1 and 11.2.1 I would like to be able to list it as such rather than having to make two or more of the same item in my table but for different classes.
I hope I have explained myself somewhat well enough. I would be happy to include the file but it wouldnt include the images for the database and it was too big for the 500kb limit.
Thank you for any help and tips you can give me.