Copying Portal Fields

[PASFKS]

Hi All, I have a database with 1 main table and 10 related tables. The main table has around 200 layouts and I have just built a navigation menu which effectively has 10 tabs and on each tab is a different portal to a related table. On each portal are 4 fields. So all up the navigation menu has 10 portals and 40 fields.

My problem is that I want to copy this navigation menu onto each of the 200 layouts but when I do so the fields in each portal are blank.

It will be a massive job (some 8000 fields) to reconnect the fields to each relationship on each layout.

One thought I had was to make the navigation menu a separate pop-up window but this does not really work for my solution.

I would be grateful if anyone has any hints on how to resolve the problem, Thanks in Advance

[bcooney]

Whoa. Can you explain this structure further? I see you're a TechNet member and Intermediate skill, so I'm giving you the benefit of the doubt, but this setup sounds fishy.

I'm assuming the main table has one record and is related to the 10 tables by cartesian joins? Can you give us a screen shot?