Need some FM to Access wisdom!!! A client wants to convert all of his FM5 files to Access 2002. (Not my choice, but the bills need paid).

The FM5 files are very basic, none of them have any relationships defined or heavy calculations, etc. Basic flat file syndrome.

However... I am having a hard time trying to figure out how to resolve a couple of "key" field issues in from FM to Access. [color:"red"] (I've already inquired the same question in some Access forums and no one knows anything about FM)

Anyway - the problems are:

(1) Several text fields are defined as "repeating" and contain up to 8 in many of the 20,000 + records. Access does not have a repeating option.

(2) Calculations - can't seem to find the proper expression in Access for this FM calculation: [color:"blue"] If(A="R","A ","")&If(C="R","C ","")&If(E="R","E ","")&If(F="R","F ","")&If(G="R","G ","")&If(K="R","K ","")&If(M="R","M ","")&If(S="R","S ","")&If(V="R","V ","")

Having been a forum member for a couple years, I know there are many intelligent database guru's that might have a clue - could you send it my way?

Thanks.

For the repeating issue you may need to create a new table/file for this data. Import the file into a temporary fmp file where upon import you split repeating fields into their own record. You may need to delete unnecessary fields but if the result is a unique key to the parent record and your data you can relate this to your main file.

You may need re-architect your calculation in access.