Hi all, hope someone can help me with this..

I've made a very simple database in which 1 field is a repeating field with 21 repetitions.

I would now like to change this repeating field into 21 separate fields on the same record - can this be done?

any advice greatfully recieved!

Yes

1. Create your new 21 fields

2. Use replace all for each of the new fields by using the GetRepetition function as follows

GetRepetition (repeating field, number)

where:

repeating field = name of your repeating field

number = repetition number

Obviously you need to make sure you are dealing with correct corresponding new field so click into "field1" and use REPLACE CONTENTS with

GetRepetition (your repeating field, 1)

and the same for field2

GetRepetition (your repeating field, 2)

and so on until field21

GetRepetition (your repeating field, 21)

In my book is there no difference in the flatness, and searches are definatly becomming more tricky to perform when splitted. You're probably raising this question because you feel that your vessel is carried by a strong wind away from repeaters ...which is a correct hunch. But littering you base with extra fields won't improve your solution as such.

But whipping up a correct relational structure isn't something you just do with out a method to approach the data at hand but you might be interchanging charateristics with subjects arbitrarily ...but you can also do it deliberatly in one direction:

http://previews.filemakermagazine.com/videos/513/DataTagging_full.mov

--sd