Doobeh

Hi there, hope you can help. On my database, I have a group of about, 10 checkboxes, two of them are quite similar, ones 'film' and the other is 'film classical' When I do a to find all those with the checkbox film checked, I also get returned the records with the film classical checked. How can I get around this, I don't want to rename the film/film classical, I just want it to be more precise when searching using checkboxes,. Any help would be greatly appreciated Regards, Doobeh.

!! Oh my You hit the nail on the head, I hadn't set the date field as a date field, only the input as the creation date, golly *rubs the egg off his face* Thank you a great deal, human stupidity should never be underestimated, especially in my case. Regards, Doobeh. [ October 15, 2001: Message edited by: Doobeh ]

Unfortunaltly it didn't work, I'll explain how I did it, because maybe I carried out one of the stages incorrectly. go into the notes db, the related one used for the portal, create a new field cdate, its indexed and is a calculation, the calculation is: dbdate (this is the date field in the notes db) with the result as a number. I dont think I could have had made a mistake about that. so I assume the problem is with the next part. I go to the main database's relationships, I have a relationship set to idno = ::idno (unique identifier for each client) then sort the related file by cdate in descending order. It doesnt actually seem to change the order of anything in the portal, so once again im lost for what to do, any more ideas, or corrections on how I went about the above? Regards, Doobeh.

Sounds like a plan I'll try it when I get back to my main computer this evening. The formatting is day/month/year because I am in England, thats how we deal with them over here across the water, filemaker seems to get the date formatting from the system, so it adapts and works fine (you can still validate via date perfectly). Thanks for the idea, I'll let you know how I get on you'll either hear cries of thanks and joy, or woe hehe, thanks again. Regards, Doobeh.

Indexing on doesnt seem to make any difference, good idea though, I'm using file maker pro 5.5, It's just beyond me why it doesn't work, maybe I have to somehow put the notes database in order, oh I not sure, a few more coffee's might help *wanders off to kitchen* Thanks for the help all, keep those ideas coming Regards, Doobeh.

Hi there, I'll give you a brief overview, I've just finished a database, and one aspect holds date ordered notes in a portal (note,date,user,id_no are the fields in the related file) The relationship is specified to sort the date desending. Okay. It works, when I enter a new note it gets shuffled depending on the date perfectly. But, and heres the kicker, I imported about.. 10,000 entries into the portal for the clients, for some reason the portal doesnt sort these entries, only new ones. Can you think why? The date is exactly the same format. So basically if i were viewing the portal for X client I might get: code: Gone Fishing Dean 27/10/2000 Went to meet Bob Mark 25/06/2001 Client agreed to work June 09/04/1998 Which obviously isnt sorting it, but if i then added 2 new entries [today and tomorrow] I would get: code: Gone Fishing Dean 27/10/2000 Went to meet Bob Mark 25/06/2001 Second Entry Doobeh 10/10/2001 First Entry Doobeh 09/10/2001 Client agreed to work June 09/04/1998 So you can see, it sorts my new entries, but totally ignores the old ones. Any ideas you can think of, it's probably quite easy (or I hope it is), but I'm quite unaware of the workaround Thankyou! Doobeh.

Hi, Essentially I want to grab all the e-mail addresses from the clients in my database, and then add a ; between each line, and then use that to send a mass mail. example user1 has clientEmail set to bob@builder.com user2 has clientEmail set to dave@gregs.com user3 has clientEmail set to hot@tot.com now, i want to grab all those records, and add a ; between then, so i end up with: bob@builder.com ; dave@gregs.com ; hot@tot.com ; then I can simply use that in the e-mail script entry in filemaker to output it to an outlook mail. sounds easy, ish whats your thoughts? Regards, Doobeh.

Hi, when im in browse mode in FM on one of my databases, and i click the right mouse button, while the button is depressed, all the black lines (surrounding text boxes etc) turn to dotted lines, its just annoying enough to make me scream is there a simple way to make the lines stay solid all the time? Regards, Doobeh.

Thats really great, thank you onno, and of course CaptKurt. Its working! Looks a bit messy at the moment, so I'll make another coffee and see if I can make the notes field resize to show all the text [read: expect another posting soon] heh.. Thank you very much, thats a big hurdle passed. I'm sure theres lots of postings on making it more appealing to the eye, so im going to dig through the old posts first. Thanks again, Doobeh.

Hi, thanks for the help, but I need a little bit more help, I suppose this will be a little off topic (for the forum), but I'll keep a copy here because of the previous posts. I'm having problems with the relationships bit. I have created a new database with three fields, DBname, DBdate and DBnote the name and date are automatically filled in. So I go back to my main databse, and start to define the relationships and then I hit the 80foot provebial brick wall. The relationship lets me relate one field in my main DB to one in another (namely the notesDB) so I assume I need to create 3 fields in the main DB that relate to each of the fields in the notesDB okay, so i link them up, allowing for creation of new records, and sorting the date on in reverse cron. order then I insert three portals, one for each field. hit browse, and I cant enter or view data in the portals. Now I know I've gone wrong somewhere, very early on I'm assuming or ive missed out a step entirely and I feel quite horrendously stupid, if you can give me a few more pointers I would be most grateful, I'm going to make myself a coffee and sit down with this for a few hours and see what I can turn up. Thanks again. Doobeh

Hi there, I've finially figured out that I need a portal to do what I need to do, which is the following: I want to create a notes section for each client in the database, the notes bit would have 3 columns, one would record the user who entered the note, the other the current date of the note, and the final one would have the note itself. Every client would have >1 note. so if you were browsing it (on a client with.. 3 notes it would look something like the following): code: Name Note Date Fred client ran away 30/07/01 Susan contract signed 23/07/01 Bob delivered contract 19/07/01 and you would input the note in a field above it, it could work the rest of the information automatically, system date, currentuser and then add it to the top of the notes 'pile' so it was reverse cron. date order I'm sorry I have to explain it like this, but I'm not at all proficient at filemaker, but am willing to learn. If you could give me any suggestions on how to get this done I would be more then grateful. Thank you in advance, Doobeh.

Hi, That you very much I got it working, its exactly what I wanted it to be, so thats a lot , im currently constructing a little totem pole in your image to give thanks to Regards, Doobeh

Hi there, In my database of contacts, each 'person' has a dateRemind field and a remindNote field. The idea is that you enter the date you want to be reminded of the remindNote. So I need help creating a script that launches upon filemaker being opened, then searches all the dateRemind fields for ones that match the current date, and upon finding any puts up a little message for the user showing the remindNote. It sounds easy in my head, but I'm a newcomer to filemaker to putting it to practise is a bit harder, any help would be most gratefully recieved I've been trying to get it working but I just am at the bottom of a learning curve and im not sure how to climb it Thanks so much, Doobeh Doob@escapee.org