I'm pretty sure I'm close. I've done a lot of reading and hours messing around with this.

I am importing some CSV data from another system export into my database here. I have a field in my form that will hold the text names of Pets with commas between them.

I have a DMC field I want to get this data into:

And each record has some associated Pets linked through their common Client:

I've written some code to find the IDs of the Pets in This Client's Pets (above) that have the same name as the names in the PETS TO BE SCHEDULED field (above). I'm pretty sure this works as I've tested displaying the IDs and they match the IDs of the pets in the main Pets table.

However, when I try to make my * Scheduled Pets DMC field match the list of determined IDs, it doesn't work.

I know I'm close.

    for r in select Appointments do
        let availPetIDs := r.'* Client'.Pets;
        let showname := "";
        let incomingPetNames := split(r.'PETS TO BE SCHEDULED', ",");
        let chosenPetIDs := [];
        for incomingPetName in incomingPetNames do
            for availPetID in availPetIDs do
                if availPetID.'* Pet Name' = incomingPetName then
                    chosenPetIDs := record(Pets,availPetID)
                end
            end
        end;
        r.('* Scheduled Pets' := chosenPetIDs)
    end

And I also tried:

    for r in select Appointments do
        let availPetIDs := r.'* Client'.Pets;
        let showname := "";
        let incomingPetNames := split(r.'PETS TO BE SCHEDULED', ",");
        let chosenPetIDs := [];
        for incomingPetName in incomingPetNames do
            chosenPetIDs := for availPetID in availPetIDs do
                    if availPetID.'* Pet Name' = incomingPetName then
                        record(Pets,availPetID)
                    end
                end
        end;
        r.('* Scheduled Pets' := chosenPetIDs)
    end

and this:

    for r in select Appointments do
        let availPetIDs := r.'* Client'.Pets;
        let showname := "";
        let incomingPetNames := split(r.'PETS TO BE SCHEDULED', ",");
        let chosenPetIDs := [];
        chosenPetIDs := for availPetID in availPetIDs do
                for incomingPetName in incomingPetNames do
                    if availPetID.'* Pet Name' = incomingPetName then
                        record(Pets,availPetID)
                    end
                end
            end;
        r.('* Scheduled Pets' := chosenPetIDs)
    end

What am I missing?