Self Join Table Error

[Thedm]

Hello,

   Can anyone point out what I am missing.

   Solution is  a Contact Manager.

   I have a simple one table solution.

   I have a 100 Records. 

   Some of the records are related and I simply need to be able to have a drop down listing all names.

   The user needs to be able to link as many names he wants by selcting them from a portal.

  

   I created a self join table using the primary key.   I linked them (it gave me a 1-1 relationship but I dont see a way to make it one to many...)

   I then created a portal selecting records from the self joined table.

  

   Now, when I create a new record it enters the full name into the first row of the portal.

   I can go into the second portal row and access the drop down of all names, but it gives a not modifiable error.

 

Any help would be appreciated.

Thanks

 

  

[jbante]

Can you show us screenshots of how you have the relationship set-up? What fields are set-up to match in each table (occurrence)?

[Lee Smith]

Or a copy of your file?