Self Join Relationship

[DGEE]

I have been trying to add a portal with a self-join relationship to our primary SUPPLIERS table/layout and can't get the function correct.

Here's what I have:

1. Added new SUPPLIER table occurrence "SUPPLIERS_Categories"

2. relationship based on;

SUPPLIERS > _kp_suppliers_id = SUPPLIERS_Categories > _kp_suppliers_id AND

SUPPLIERS > category1 = SUPPLIERS_Categories > category1

3. created a new portal "Category_Portal" in the SUPPLIERS layout with all the portal category fields from "SUPPLIERS_Categories" table reference.

I have added a new scripted button:

* Go to Object [Object Name: "Category_Portal"]

* Go to Portal Row [Last]

* Go to Field [sUPPLIERS_Categories::category1]

But every thing I try does not work. I've allowed creation of records from both, or just one or the other above tables... the relationship does see each other, but when using the "Add New" button, it either adds a new contact file as well as adding a new category, or the new category reverts to the initial category, or does something funky and removes all the categories until I click out of the record and come back.... I have no clue.

Any suggestions are much appreciated, thanks.

[Fitch]

Allow creation using a self-join? That can't be good. Categories should be a separate table.