I have a simple point layer with pointIDs, and a standalone table with time values and pointIDs. The time values are in hourly intervals (start+end times over a single day). The pointIDs repeat in the time table, so there are 24 entries per pointID.
When I do a relate, the time option doesn't recognize any field. When I do a join, only one row from the table is used. I faintly remember being able to export a 1:n join to end up with a feature containing duplicate points or each join, but I can't replicate it.
As a workaround I extracted and joined the XYZ coordinates of the points in Excel and created a layer for that but that's pretty convoluted..