You can use aggregate functions like sum, max, average etc. with repeating fields and get the sum or other function of all the repetitions.
Sum ( Repeatingfield ) , for example totals up all the values in the repetitions.
Well my first problem is the display date is a repeating field showing 1/1/10 1/2/10 1/3/10
Then i made the relation between the display date and the packing slip ship date (ship date is not a repeating field).
How do i make the packing slip ship date show up on the calendar?
If i put a ship date field on top of the display date then nothing happens.
I'm just unsure how to have the repeating display date get the orders that shipepd on the date shown on the repetition and add them up.
Don't think that relationship will work for you. A repeating field works just like a list of return separated values when used as a match field in a relationship. If you have 1/1/10, 1/2/10, 1/3/10 in different repetitions of the same field, they will match any fields in the related table that have dates of 1/1/10 OR 1/2/10 OR 1/3/10...
So if the repeating field is working fine to result the calendar days, is there anything that i can do to show an additional data in relation to those calendar days?
I don't see how you can implement what you want with a repeating field of dates. You may want to investigate other calendar tools and see if one of them has a different approach that works or maybe someone else here on the forum can conceive of a way.
As far as I can figure, you'd need separate date fields--each with a separate relationship for each day of your week--in order to get a list of matching records for each day.