In MS Access I am trying to enable efficient data entry by allowing the user to specify a group of people as a singular list, then extrapolate this into a full list of records covering the range of pair combinations (rather than entering these all separately), excluding matching pairs.

For example, 4 distinct Person_ID are observed at an event together on a given date. I would like the user to be able to enter the list of all the various persons involved, along with the date and other attributes;

PERSONS | LINK TYPE | DATE

Person_ID1 | observed with | date
Person_ID2
Person_ID3
Person_ID4

I would like the macro/VBA to then extrapolate this into a table similar to below;

PERSON1 | LINK TYPE | PERSON2 | DATE

Person_ID1 | observed with | Person_ID2 | date
Person_ID1 | observed with | Person_ID3 | date
Person_ID1 | observed with | Person_ID4 | date
Person_ID2 | observed with | Person_ID1 | date
Person_ID2 | observed with | Person_ID3 | date
Person_ID2 | observed with | Person_ID4 | date
Person_ID3 | observed with | Person_ID1 | date
Person_ID3 | observed with | Person_ID2 | date
Person_ID3 | observed with | Person_ID4 | date
Person_ID4 | observed with | Person_ID1 | date
Person_ID4 | observed with | Person_ID2 | date
Person_ID4 | observed with | Person_ID3 | date

Any strategies or similar examples greatly appreciated!

Still grappling with basic VBA but solid foundation with Access principles