Hello,
I've created a database where photo-information will be stored. Every photo is linked to one or more categories. The categories are stored in a seperate table. Because a photo can be linked to more categories and vice versa, I've created a table connecting categories and photos, containing photoID and CategoryID.
Now I want to display in my form the photo-information and linked categories. However, this is dynamic: when I add a new category and link a photo to it, I wanna see this in my form too. I've tried to manage this by creating crossqueries and link them to my form, but I didn't get the desired result.
Is there a way to create a form where I can display the linked categories per photo as well as the photo-information itself?
Any help will be greatly appreciated! Thanks!
I've created a database where photo-information will be stored. Every photo is linked to one or more categories. The categories are stored in a seperate table. Because a photo can be linked to more categories and vice versa, I've created a table connecting categories and photos, containing photoID and CategoryID.
Now I want to display in my form the photo-information and linked categories. However, this is dynamic: when I add a new category and link a photo to it, I wanna see this in my form too. I've tried to manage this by creating crossqueries and link them to my form, but I didn't get the desired result.
Is there a way to create a form where I can display the linked categories per photo as well as the photo-information itself?
Any help will be greatly appreciated! Thanks!
Is this really that difficult or didn't I make myself clear enough?
