I’m trying to create a Pet sitting app. I have a Sales table linked to Customers, with CustomerKey as a foreign key on the Pets table.
When I create a new sale for CustomerKey, I want to be able to choose multiple pets, using PetKey and create a new row for each selected pet instead of comma-separated keys so the relationship is maintained. Is this possible?
LinkedIn
Twitter
