And why do you need to do this? (Sometimes, if we back up and look at the big picture, a better alternative becomes possible.)
I see why it may seem silly, But I have a database with only 1 record (yes I realise using Filemaker for this is overkill).
On this record I have lets say 10 groups of data. Each group of data has lets say 25 fields.
10 x 25 = 250 Fields total.
If I want the data in group one to be switched with the data in group two, that is quite a lot of scripting to do that.
Im not afraid of doing it, I just hate to find out my script of 300 lines could have been done in 30 lines.
Yes, but there's no need to do this at all at the field level. That's why I asked the question.
Make your "10 groups of data" 10 related records in a separate table. Each record can consist of your 25 fields. Then, instead of physically copying the data from one field to another over and over, just change the value of one field so that it matches to a different record or group of records. Much simpler, don't you think?
How would you select the two groups to be swapped?
Phil's method above is how I see it would normally work in a normal database, thank you.
This particular database I am working on now, is nothing more than a glorified word processing document done in Filemaker pro.
Currently I wrote a script to do the following:
Set Field C to the contents of Field A
Set Field A to the contents of Field B
Set Field B to the contents of Field C
(Field C is a Temporary field not shown anywhere on the layout)
I was only wondering if there was a quicker way to do exactly that, instead of having to do it the "hard" way.
Can you provide a more detailed example? I have yet to see any reason not to do this the "normal" way.
Well the way described above shows multiple records,, this database has 1 record, and will never have any more than that.
So it is one record, one layout, with multiple groups of fields, all on one page.
As I mentioned earlier, this is not a typical "database".
Yes, but you haven't explained why this has to be a single record. Nothing you have described so far explains why that is necessary.