It's probably that you need to give your globals a value when opening the solution.
Local FM databases keep their globals when you close the file. On the server they are only kept in the clients RAM.
Thanks for reply.
I toke the database out from server and stored the global value and uploaded the database again to the server. The global value is always there when I open the database.
If I create a portal in Contact layout it works fine all records with "To-Do" values will be shown.
Check the format on your "Done"-fields. They should both be text. (Even though I suggest that you make them numerical and have "1" if the field is true (ie "Done") and nothing if it aint true.)
Format of all fields are the same "text" I can not change it to numeric because it is an old database.
Then I should look if the relationships work one-to-one. That should give some clue to what's wrong.
Sorry, I don't have any better ideas. It's probably a "OMG, it was that simple"-problem... ;)
sorry I didn't understand OMG. the relation is working with Conatct.contactid = Queries.contactid but when I put the second relation Contact.Donequires ≠ Quires.Done it doen'y show any record.