Relationship Change Confusion

[himesly]

I am so confused right now i'm about ready to toss my laptop out the window. My problem is relationships, specifically how to change one once I have one established. I have 5 databases. 1 main one and 4 children.

The way I have the relationship set up now it is to name. However after reading more and learning more about FileMaker Pro I discovered the auto entry serial number option. I beleive this would be a better relationship to have as it will always be unique. The problem is the database is already in use and already has over 104 files in it.

I've searched the forums and have found a few other tips on how to do this but I was unable to make any of them work for me. I simply want to set it up so now the serial number is the relationship instead of the name. This is probably a pretty simple procedure but I'm not familiar enough with the program and way of thinking behind it to figure it out.

If any one could please help me I would appreciate it.

Jessica

[Computer Geek]

Just a thought ---

1- Add a field for the index number to all the tables

2 - Write a script that goes starts at record #1. Have it set the field for the index number in all the tables to 1.

3 - Have it go to the next record and repeat until the end.

4 - Go to the the database tables and set the index number field to auto enter to whatever the last number was plus 1. (Probably 105)

5 - Reset your relationships to use the index fields.