Hi
Im sure its a simple thing and done all the time but I cannot get the right settings and so far forum searches have not yielded the answer so I hope someone can point me in the correct direction.
I have a form which has a repeatable group in it. Its a booking forms and the majority on the information is linear but the size of advert, area and date are in a repeat group so they can book more than one against the same details.
In the list view I get as many duplicate entries as I have grouped items plus one... I see whats happening, there is the primary and then all the groups having the same id and date.
I really want to show distinct, so that if I have an entry it shows just the one not one for all the groups as well.
I tried group by but thats not really it.
In the image you see the entry davis cars, its because there is the record and a repeat.
The one with 3 is a record and 2 repeat groups.
I just want to show one for each of them so no date time is shown more than once.
Clicking any takes you to the same record anyway.
How can this be achieved?
Im sure its a simple thing and done all the time but I cannot get the right settings and so far forum searches have not yielded the answer so I hope someone can point me in the correct direction.
I have a form which has a repeatable group in it. Its a booking forms and the majority on the information is linear but the size of advert, area and date are in a repeat group so they can book more than one against the same details.
In the list view I get as many duplicate entries as I have grouped items plus one... I see whats happening, there is the primary and then all the groups having the same id and date.
I really want to show distinct, so that if I have an entry it shows just the one not one for all the groups as well.
I tried group by but thats not really it.
In the image you see the entry davis cars, its because there is the record and a repeat.
The one with 3 is a record and 2 repeat groups.
I just want to show one for each of them so no date time is shown more than once.
Clicking any takes you to the same record anyway.
How can this be achieved?