Group by in a form???

[k0r54]

Hi,

I have a table that contains a list of calls made, it has a field called Line Add. Now Line Add is a certain object, so in the database there could be 20 calls based on the Line Add.

What i need the form to do is have a next and previous button, but rather than just going to the next line. It need to go through the line address and inside there have a datagrid of something like that displaying all the calls made on that line address. So when i press next it displays the next line address and all there calls and so on.

I do not need to modify the calls displayed.

Any ideas on how to do this, I am rather stumped.

Thanks
k0r54

 

[Rich]

Yes, normalise your data, you have a one to many relationship between
Line Add and calls made

 

[k0r54]

How do i do that??

 

[k0r54]

They are all in the same database you know??