You can use compound unique ID - two fields can be set as primary key but that means saving both values into child table records as foreign key. However, don't think this will be compatible with multi-value field.

Custom unique ID is common topic. Start with a review of https://www.accessforums.net/forms/a...ing-23329.html