I have a contacts form with multiple subforms with in it. I need to show that any one record could be related to several other records in the same form ( One to many relationship between multiple records in the same table)
The method I attempted was to create a relationships table with a lookup pointing to the contacts form. I then placed this relationship form as a subform in the contacts table.
The view displays properly and seems to work however the contacts form crashes with the unable to display error message.
Is there a better method to acomplish a one to many relationship between multiple records in the same table?
Thanks in advance