Hello,

I was wondering if someone can help me with this. i created a relationship between Databases, one is call Student Files and second one is call Event Schedule. Basically student are assign to events being input at the Event Schedule, which get display at Student Files DB. I am running Mac os X Server with FM 5.5v4.

This used to work fine until the Event Schedule started having some issue where it wouldn't let anyone add schedule to it. I did check on the DB's,there was some problems. I end up doing a recover of it. It is working now but it seen the relationship between both of them got broken.

Now when someone try to add students to the events schedule, it says cannot find Event Schedule DB even though you are in the Event Schedule DB. I try to point to where the Event Schedule DB is but it is not saving the relationship between both of them.

Does the relationship link need to be done where the Files are located on the server or can i do from my client computer?.

thank you

victor

Does the relationship link need to be done where the Files are located on the server or can i do from my client computer?.

As I remember FM5S can't you do anything but define new scripts and enter raw data when the service is running. The server needs to be shut down, and an ordinary clientversion is going to fix the relation between the files in the served folder!

Even with newer versions, isn't what you suggest among best practice:

http://network.datatude.net/viewtopic.php?t=240

--sd

Thanks for the help. I will change at the server using the client software I have install.

I usually make changes to the DB before employees come in to work in the morning.

Soren, you're wrong. If you are logged in from another machine as the sole user of files running on Server, you can define fields. Whether sole user or not you can create relationships. However, in old FileMaker (pre-7) I much prefer to create relationships when not using server and when sharing is turned OFF for FileMaker. You can then create relations as relative-only which is usually the best way.

Soren, you're wrong

Ha ha it sometimes happens, and I admit that server deployment not is my bread and butter ...and tend to keep away from hardware'ish diciplines if I can be helped. To me is it too hunch based diagnostics of fads ...I prefere my improvisations to be knowledgebased ,)

--sd