Help!

I just got filemakerpro5 for the new project we are working on and I know it can do wonders, but for now I cannot do even little things.

I have numerous excel databases, each one representing a set of people and their status for every day of the week. Some of the people stay around for a while, others leave right away. I was able to convert my databases to filemaker, but how do I merge the files, so that if there is new information in the fields, it is updated, and if there is not, it is not updated, and new records are added.

I am so frustrated, I read the whole manual and looked at all help files, nothing makes sense. Please Help.

quote:

---

Originally posted by Jenka:

Help!

I just got filemakerpro5 for the new project we are working on and I know it can do wonders, but for now I cannot do even little things.

I have numerous excel databases, each one representing a set of people and their status for every day of the week. Some of the people stay around for a while, others leave right away. I was able to convert my databases to filemaker, but how do I merge the files, so that if there is new information in the fields, it is updated, and if there is not, it is not updated, and new records are added.

I am so frustrated, I read the whole manual and looked at all help files, nothing makes sense. Please Help.

---

Pick one of your new FMP files, it matters not which one. From that file use the Import function to import the data from all the other files.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Thanks for your reply, I tried that, unfortunately what happened is that the records that had fields completed in the original document, were not filled out in the following day's document. So when I updated using the import function, those records were emptied out. For example:

Day 1:

John yes 1 5

Jim yes

Day 2:

John yes

Jim yes 2 13

Joe no 3

What I got for the final product is:

John yes

Jim yes 2 13

Joe no 3

What I want to get is:

John yes 1 5

Jim yes 2 13

Joe no 3

I do appreciate any little hints you have for me.