errorist

Simple problem but i can't figure it out. i have some fields with a date-format, but i need them to be automatically filled with the text "N/A" if an option is checked in another field. I tried calculations but the outcome needs to be a date and cannot be text, so N/A changes into "?" because text is not accepted I can switch the format of the datefield to text but that's not really a good option. How do i get a text outcome in a date-restricted field? thanks

This might be the dumbest question ever, but i can't figure this out. I store emailadresses in a seperate database (file 2) and made a relation with the main database (file 1) so the emailadress from file 2 automaticly appear in the fields from file 1 when needed. I noticed that FM automaticly opens the file that contains the emailadresses. Is there a way to get data from file 2 without having it opened while working in file 1? I just don't want my users to see this file appear (eventhough it's mimimized) because they have no business there. thanks in advance.

someone should convince my boss Thanx for the replies.

My FM5.5 application (12mb size) is used by 8 or 10 users at the same time (no fm server). Every now and then the app freezes and the mousepointer changes into a coffeecup. What does this mean, is there a lag in the network, or are there too many users? Thanks in advance.

Thanx alot for your kind replies guys. It was indeed quite simple, just useing one search with <= and >= before the searched number did fine. Another problem now is, FM doesnt make difference in ticket AA12345 or BZ12345. That means i'm probably will have to split the letters and the numbers, as soon as the records are imported from disk. Still trying to figure this one out.

I have to make the following database, in this example: there's a box with tickets. The box number is 1418. in the box are 1000 tickets, all numbered unique. The range of tickets in this box is AB2000 to AB3000 Now, one should be able to find in what boxnumber a certain ticket is. So, when looking for ticket ab2512 the database should show box 1418. So far, i cannot figure out who to to this, other than generate 1000 individual records, one for every ticket in the box. But i'm sure there's another way Thanx in advance !