Hello,

I have a datbase of talk show guests, however I need to input 5-10 different contact numbers and email addresses per guest. I tried this when I first started with FM and I used repeating fields, not going that way now. I want to use a portal, however how can I do this with a self-join relationship when there are over 25 other fields besides the email address or telephone number fields? Wouldn't I be creating duplicate Guests in our database in order to put in one phone number or email address per record?

Thanks and God Bless!

David

A self-join doesn't really make sense here, since the parent entity is about a 'Show' or 'Episode', and the child entity is about a 'Guest_Appearance'. I'd suggest separate tables for each distinct entity. See attached.