I dont now where to start, so I'm starting from the beginning.

I want to make a page where people of a company can leave short messages for each other.

I have created two tabels called:
Users and Messages

Users has columns called:
ID first_name, Last_name, adres, zipcode, etc.

Messages has columns called:
ID, U_ID, name_poster, receiver, message, and datestamp.

ID is the primaire key in the Users tabel, which is related to U_ID in the Messages tabel.

What I want to do is the following:

On a page I want to show the names of people with there messages. In the first row the name, in the second row and the rows undernead, there messages with all the specific information.

After the first name (with his or her messages) comes the second name with her or his messages etc. etc.

How do I have to setup my recordset and dbase? Do I need one recordset, two, or more. If I need two recordsets, how do I have to use the repeat region behaviour ? Do I have to repeat the messages region in the users region?

For example: A message for Pete has to be listed under the name Pete

Thanks already