Value List Corruption

[RPCia]

Here is what I was doing lets see if anyone can help.

• First I created 4 value lists in File 1 (logicFile)
  
• Second in File 2 I created 4 values lists using the exact same names as the lists in the other file that pointed to the original lists
  
• Third I wanted to add another list in File 1 so I went into the define Value List and selected one that had a similar name to the one I was going to create hit Duplicate and then I lost all my lists

Now the value list screen in both files shows blank lines File 1 has 5 lists and file 2 has 4 blank lines where the lists were.

My speculation is that when I duplicated the Value List for some reason it may have keept the same list name which is causing FMP to not recognize any of them. This is just a guess though.

I am not as concerned about the logic file(file 1) as I am with File 2. It is my main file I would not want any corruption in it.

What I have tried so far

• Tried deleting the value lists, did nothing
  
• Doing a DDR Report, shows for all 5 lists
  
• Taking File 1 offline and trying to repair it was no help

If anyone has any suggestions or has experienced this before please let me know.

[RPCia]

Scratch that, Recovering the file caused all the value lists to be reset so now I have 0 in my recovered file.

I am going to restore a backup of the logic file, the second File, I am sure File 2 will have to be restored from backup as well