I'm trying to create a very simple gallery, with comment system.
I have one table named Photo, which contains a field named MyImage defined as Attachemt.
I also have one table named Comments, with the field MyText defined as Text.
I want to show the results in a form, just like a typical image gallery:
First Record:
Photo 1
Comment 1 from Photo 1
Comment 2 from Photo 1
.
.
Comment n from Photo 1
Second Record:
Photo 2
Comment 1 from Photo 2
Comment 2 from Photo 2
.
.
Comment n from Photo 2
etc
I created a simple query from the Photo table, but if the photo has more than one comments, it gives me more than one results in the form too. For example, these are the results for 3 comments in one photo:
First Record:
Photo 1
Comment 1 from Photo 1
Second Record:
Photo 1
Comment 2 from Photo 1
Third Record:
Photo 1
Comment 3 from Photo 1
Can anyone help me? I'm newbie at Access and I don't know what I'm doing wrong.
I have one table named Photo, which contains a field named MyImage defined as Attachemt.
I also have one table named Comments, with the field MyText defined as Text.
I want to show the results in a form, just like a typical image gallery:
First Record:
Photo 1
Comment 1 from Photo 1
Comment 2 from Photo 1
.
.
Comment n from Photo 1
Second Record:
Photo 2
Comment 1 from Photo 2
Comment 2 from Photo 2
.
.
Comment n from Photo 2
etc
I created a simple query from the Photo table, but if the photo has more than one comments, it gives me more than one results in the form too. For example, these are the results for 3 comments in one photo:
First Record:
Photo 1
Comment 1 from Photo 1
Second Record:
Photo 1
Comment 2 from Photo 1
Third Record:
Photo 1
Comment 3 from Photo 1
Can anyone help me? I'm newbie at Access and I don't know what I'm doing wrong.
