I have 2 tables in a base. One table has information on Children. The other table has information on the Sponsors for children. I have a field in Children table that links to the Sponsors table and allows multiple links denoting the particular sponsors of that child. Is there a way to take the sponsors from the multiple link field and put each one into their own linked field (sponsor 1, sponsor2, sponsor3, etc)?
Thanks in advance for any help,