Duplicating layout and record

[justcosmic]

...ok so now I have successfully loaded the files, heres a quick explanation:

go to a layout in PB designer such as 48 holes row or 24 holes row...if you click on the thin purple repeating field just below the "hole" field, you will soon see what I am trying to achieve: just to recap. it works fine except the fact that its using lookups & therefore adding unneccessary file size...

...hope that all makes some sense.....

[-Queue-]

Sorry, but only one of your files, Vortex Patch Holes, made it into the zip. Try zipping your files again, editing your previous message, and posting the new zip in place of the original one.

[justcosmic]

...there should have been 2 zips...so here's the other one

vortexPBdesigner.zip

[-Queue-]

You can only post one attachment at a time. It is easier if you zip both files together and then post a single zip.

After reviewing the file, I don't think there will be an easier way to do this. I thought that using a single repeating container field and a GetRepetition calculation might work, but then I remembered that GetRepetition has a bug in version 5 which can be worked around for other types of fields, but not containers.

So, unless someone else has a better idea, I would say the way you are doing it now is the best that can be done until you upgrade to version 7.

[justcosmic]

...well thanks very much for taking the time to look it over...I really appreciate how helpful you have been...

....oh,,,but would this work:

...in PB designer, I add new matchfields (I'll need lots though...is there a limit??)& for each new match field a new relationship(are there limits there too?) and then instead of repeating container fields, I insert the related field on the layout multiple times....each time "via" a different relationship....I'm sure it will work except for the stupid amounts of fields & relationships...& I wonder even if it does work, if it is good practice to use that many(i.e. does it cause problems....etc)

....perhaps i will wait for some feedback before i lunge to far ahead...

...of course i am presuming that you cant build relationships based on a particular repetition of a repeating field...(i have looked & cant see any way of doing that)

....amny thanks again....

[-Queue-]

Yes, you can do that, and I highly doubt you'll ever approach a limit to the number of relationships or fields. I never have and I've used over 300 fields for a single report before.

I wonder, though, if it's really worth it to go to all that trouble rather than to purchase a larger hard drive that would make the file size a non-issue. It would probably cost you more to overhaul your design than to buy a new one. Just a thought.

[bruceR]

no i don't want two identical files. I want two layouts including its records to exist in two separate files.

Why?