show expanded attacment pictures as per file name

[aspen]

hi guys
I have a childrens pictures database with one table "Table1" I build a query based on the table and expanded the attachment field.My Continious Form is based on that query. So my form shows each the attachments in the particular record in the table, in a seperate raw with the same ID as the table. So if i have three Pictures in ID 1 of the table, My form has 3 records With ID 1 and and containing the file name and The attachments. The problem is each record shows the file name correctly But 3 the attachments and
the same picture is displayed in the 3 records also. so is there a way to display the particular picture that the file name points to, for the three records. supose if table1 first record contains three records a,b and c ,the continuous form would show picture a for the first record, b for the second and c for the third. just like file names a,b and c are autameticaly for the file name field. can some one please help me do it.

Thank you

[Robeen]

Can you post the design of your Table here for us?
Or a screenshot of the Table either in Design View - or in Datasheet View?

Just from what you said above, it sounds like your Table is breaking one of the basic rules of database 'Normalization'.

If you google 'database normalization' - or 'first normal form', you will be able to understand the problem and may be able to fix it yourself.

But let us know if you still need help!

[aspen]

sample.zip
Hi robeen
Thanks
Here is my table and query. Now if you build a multiple item form based on the query. there are 2 records with the same id with two diferent file names for the two records
and the same two attachments for each record.and displaying the same picture for each record. Can we make it display the two different picturs for the two records. Please help
Thank you

[Robeen]

I created a New Form using 'Form Design'.
Then I clicked 'Property Sheet' button [on top] -> Data Tab - > Record Source.
In the down-arrow for Record Source, I selected 'Query 1'.
Then I clicked the 'Add Existing Fields' button [on top] and dragged and dropped ID, Table1.Files.FileName, and Files.FileData - to the Form.
Now - when I ran the Form - I saw record '1 of 2 at the bottom of the form.
And I saw the picture of Aman_b.jpg.
When I clicked the right arrow at the bottom of the Form I went to record 2.
And I saw the picture of 317383_109994729107185_100002899748032_53574_29359 58_n.jpg.

Then - I went back to Form Design View -> Property Sheet -> Format -> Default View.
It said Single Form [one record at a time] - as I described above.
I changed Single Form to 'Continuous Forms'.
Now when I ran the Form, I saw Aman first - and when I scrolled down - I got the other picture.

Is this kind of what you needed to do?

[aspen]

Hi robeen
Thank you very much
When i posted this thread i thought that its impossiple from what I read on my rushed searches on the net. and soon you have made this possible for me. Thank you very much. may you live forever. Yes thats exactly how I wanted it. you are really great

Thank you very much

[Robeen]

You're welcome, Aspen! I'm happy I could help.

[aspen]

Thanks
Thanks a million