This is multiple steps, but you can do a rollup on your relation to get a max date for example, build a template with the rollup date and whatever you used for your previous relation in the sheet containing the relation and The sheet you are relating to. Then create a new single relation using the template to get only the last record. It’s a lot of Glide columns, but it’s better than a completely separate sheet and duplicated data.