Robert's older brother James was likely the James who fought as a gunner at Waterloo. It would naturally inspired Robert to join the Royal Artillery. James won a medal in 1815, and Robert joined in 1804. James record was tossed as are all records from that time.
Robert's discharge was a duplicate and not discarded, which is fortunate for us.