maybe someone can help mi fix thi:

[caro3252]

Hey guys! I'm having some issues with an aplication and though that maybe someone here could help me.

I'm running an aplication that uses 17-20 different databases. It was created using FM 6, it is running on a windos xp os, using a filemaker server 5.5.

the application is opened using a "start_up" scrip which initializes the file to verify the user. the application verifies the user by pulling information from a "users" database, and comparing to entered information.

My problem is that if someone is logged into the databases, and someone else goes in, the system can not figure out what is going on..... o.k., let me see if I can explain this a bit better. the first screen that loads after an user is verified, is an "index" page where the user decided what the want to do. In this screen the name of the user is displayed (it goes to the user db and read which "actual" name is associated to that particular username, and displays that info.) when someone else logs on (with their unique username as password), the new user display the correct information on its screen, but one the screen of the user that was already logged on, the name changes from its own to the name of the person that has just logged in. This has becomed a big problem, becuase the system go into infinity loops and multiple error messages most of them involving "you can not make any changes to this record because some else is using it".... and even worse, when one of the user navigates the different layout of the program, the other person screen changes as well

does anyone knows what the problem might be, and what I could do to solve it?:

thanks in advance

[Reed]

What file contains the index page? Does it contain a relationship to the users file? What is the key field? Are the fields that show the info about the user regular fields or globals?

Are the two different users who seem to move to the same layout together on two different computers? Is your server on another separate machine? What is your exact setup?

None of this sounds like anything that I've seen happen (Using fmserver 5.5v4 on MacOS 10.2.8 and 5.5v2, 6.0v4 clients on MacOS 10.3.4, WinXP SP1, and Win2000 SP5.) More info is necessary to troubleshoot this problem.

[caro3252]

I'm attaching some of the main db of the aplication....I took over the responsability for this program after the original programer was fired... so while a lot of the relationships/variables/scripts were written by me, some where not so...... I'm not sure if I can answer all the details you requested.

the "index" layout is in the "main" db.

it does have a relationship to user (in a runabout way.... the "main" connects to the "login" db which connects to the "users" db.

yes, the two users are on separate machines.

the server is on a separate machine. We have aserver that the whole company uses. each terminal in the network connects to it.... the filemaker server 5.5 resides on the company's server

I apreciate any help you can give me... if you need any additional information please let me know :-(

fmforum.zip

[Reed]

The fact that your username display field is a standard text field in a file with one record explains why each user sees the same value. If you want each session to see a different value, you need to use globals. (Or have a different record for each session) This also explains the "record in use" errors. Filemaker won't allow a record to be modified by 2 users at the same time... if you could do that, there would be plenty of other problems to deal with.

I can't see why changing layouts on one file would cause the layout to change for another user. I can't see the whole solution, since some files are missing and some have passwords while others do not. Can you explain (using the files you posted) exactly how to make the layouts change on a remote machine? I'll see if I can reproduce that here...

Dana

[caro3252]

YES!! I finally have some idea of what I need to do to fix.... (unfortunately, not all of it, but I shouldn't complain)... Any chance you could tell me which fields need to be global?: the one in the user db?? the one on the login db??? the main db???

Somehow I have the impression that if I fix this, then all the other issues will solve themselves..... I think I didn't know/understant what the program was doing and though it was changing the layout on other screen...... it probably was all a matter of declaring the variables correctly....

Again, thanks, and if you could help mer figure out which variable I need to change, I would really apreciate it (... otherwise it is going to be a very long weekend trying to change all of them.

Carolina