Having two record sets

[simontheu]

What i want is a table of pictures and comments.

Pictures on the left, and the four most recent comments about the pictures on the right.

I have a database table of pictures, with a picture ID as unique, and also a comments table, also having the picture ID, how can i get a recordset from both at the same time??

[D3mon]

use a JOIN in your databse query, based on the matching PictureID.
Which database are you using?

[simontheu]

access, if I do a join how will the recordset be arranged?

because the amount of comments is many to one picture.

I shall try it and see what happens

[D3mon]

you'll need to 'group by' the PictureID I think

[simontheu]

i have made a query in my access database which seems to do the trick, couldnt get the SELECT FROM to work, kept getting FROM syntax error

[Rob]

For acceesm try 'Select * From'

[spinal007]

I know I'm late, but I don't think you cant use "SELECT *" when joining tables

also, he wants to get one record from the pictures table and 4 from the comments table.
best to do is:
- load picture record
- save id as a variable
- close picture recordset
- load comments used the saved id
- blah blah blah...

[Webforumz Staff]

One method is called data shaping. It let's you return a recordset as a field in another recordset. (I know that's not a very clear description)

Check out http://www.4guysfromrolla.com/webtech/092599-1.shtml or google it.