I thought I could just go into Manage Database > Relationships and on the Cap Inventory table, create another link from capPartNumber to capPartNumber2 on the estimate form and capPartNumber (Cap Inventory table) to capPartNumber3 on the estimate form. But when I tried that I lose all pictures - nothing pops into the portals when I select a part number on either section.
Same goes for lid pitch.
Never mind . . . .:-)
Went under Relationships and click on the Edit Relationships tab. When I tried putting the relationships together it kinda told me what my problem was. I needed to create copies of Cap_Inventory and Lid_Pitch tables for each section and then link. . . . problem solved.
This works, but if anyone knows of a better way, I'm all ears.