1 of 1 people found this helpful
What you are describing is called a "self join".
Open Manage | Database | Relationships
Find the Table Occurrence box for your table and click to select it.
Click the duplicate button (two green plus signs)
Drag from your foreign key field in the one box to the foreign key field in the other.
Go back to your layout and put a portal to this new table occurrence on your layout.
Please note that you have NOT created a new table by doing this. You have just created a new Occurrence of, a way to reference, an existing table.
Thank you philmfdjunk. This worked!!! I appreciate your help!