Sorting/ Group 1 Row in more then one row

[Andre1]

Good evening all,

i try to code an app for my rental. My database have this layout:
Name Pickupdate Returndate Ispickuped
Person1 Monday Friday 1
Person2 Tuesday Friday 0
Person3 Wednesday Saturday 0

I use the deck view and sort the rows grouped by days. I sort it by days. If bike is not picked up i use the pickup date when it is picked up i use the return date for sorting. Now its looks like this:

Tuesday
Person2 Pickup

Wednesday
Person3 Pickup

Friday
Person1 Return

But now i find out for my plannings its better to have this grouped by pickup and return date, like this:

Person1 Monday Friday 1
Person2 Tuesday Friday 0
Person3 Wednesday Saturday 0

Tuesday
Person2 Pickup

Wednesday
Person3 Pickup

Friday
Person1 Return
Person2 Return

Saturday
Person3 Return

Hope you unterstand what i mean. I cant find out if its possible or how its posible.

[Marc_Dillon]

I think you’re asking how to show the same record twice in one view. That will not be possible.

One option for you would be to have 2 separate records per bike, a pickup record, and a return record, all in the same Table. That way you would be able to see the 2 records per bike in the same view.