I have a layout that tracks time spent on a project by staff members. There is a link to the Staff Assignment table and the STAFF table through the staff id. The layout shows the info correctly:
but when I export the data as an .xls file, the time and IDs are correct but the names are switched. The names are all there but not shown with the matching ID. For instance, Staff ID 1292 should go with Name 1 but it is shown with Name 4.
Any ideas on why this happens?