Group Edit ... best technique ?

[GrantSymon]

Hi,

I'm planning on including a 'group edit' script in my address database, so that I can edit a number of address records at the same time (like if a company address has changed and I have 20 different records for different people in the company) and I would like to ask if anyone has any advice about the best way to go about it.

I thought the best way to do this, is to create 'global' fields to 'mimic' the normal ones, then from a group of records in a portal, set the global fields to the same values as one of the records ... via a script. Then I can edit the info in the 'global' fields and once it's the way I want it, run a second script to change/set this new info into the other related records.

I have 3 address 'tabs' and other info fields. In total there are around 30 fields.

I also have 8 different 'tabs' and different portal/relationships in each one.

So ... this is going to be a big and complicated thing for me to implement.

Does anyone have any advice, as to whether this is a good way to go about it, or should I be doing this differently ?

Many thanks for any info/advice. :

Grant

[Genx]

... your structure isnt all that great... why didnt you just make a company table and put the address in there and then relate your employees to that company by the company id or something... i mean then you'd only have to change the address once... and any other company details were they to change...

try not to over complicate things where you dont need to... i mean this script your planning is a bit to elaborate where a simple company to employee relationship could solve your problem..

genx

[GrantSymon]

Hi aflgenx,

thanks for the wake-up call!

I've just implemented a scripted solution for group editing of 'Keywording' in records ... which works well and I was sort of 'continuing along the same lines' and thinking the same way. But you know you're right. I only really need to group edit addresses and tel numbers, so a Company table will be the best way to do that. Thanks!

Grant