Title
Many to Many in a portal
Post
I have a many to many portal whereby I do a self join of categories with lookups into Product Description and Product ID.
When I select a category, i.e. Hardware, I get the proper Product Descriptions on the right number of rows but only one product ID
on the top line of the portal. I need the product IDs to load just like the descriptions in order to drag and drop the right one into
the parent table. Is there any way to get the product IDs to load as per the product descriptions. Any help on this would be terrific.
I know I am close on this, I hope but one never knows.
You'll need to describe your relationship in more detail or upload a screen shot.
By what field in each table occurrence do you match records?
What exactly do you do when you "select a category"? (Perform a find, select a value from a value list...?)
From what you describe, this doesn't sound like an actual "many to many self join relationship" as that usually entails an additional table to serve as the "join" table linking the two occurrences of your self joined table.