Jump to content

falkaholic

Members
  • Content Count

    500
  • Joined

  • Last visited

Community Reputation

0 Neutral

About falkaholic

  • Rank
    member

Profile Information

  • Gender
    Not Telling
  1. Thanks! That helped. Got it working, rebuild the whole chain and its works now.
  2. You're correct with you're takes. Here's a shot of the relation (have tried other ways). Â There can be more than one course per day but I dont see how another join table could fit in isn't relating to a day of the week to courses::day act as one ? Â Thanks. ,
  3. I have a relation that doesnt seem to work right. I can't see to get my head around what is wrong. It for a school - tracking absences. Each class is once a week and has a weekday (courseDay). Each class has the tipical many-to-many of courses and student enrolled in it (Course_Students). I have made a dashboard that takes the a day of the week to show the students that should be in the school for all classes on that date. The relation is: Dashboard::date_of_week -> Courses::courseDay -> Course_Students::courseID -> Students::studentID When listed in a portal, all the course names are the same and there isnt the correct students. I have tried re-arranging the relations but still the same. Feels like it something really simple but am I doing something like this correctly? Thanks for any pointers.
  4. Thanks. I did end up reworking it all so the are all records. Then used calculated keys to filter out the alternate weeks.
  5. I am racking my brain for a solid solution to scheduling problem. I have a system where the client had weekly events schedule, except for holiday and other closurs. A list a date would be supplied to clients so they didn't come in on the weekly appointment on closure days. To do this, I had fields for each day of the week, and start and end dates for the seasons. Then populated each field with a script that took the start day, and added 7 until the end date. Then allowed the user to take off closure dates and then the list for the relevant day was supplied the client. A new requirement is to add the option for appointments of either weekly, or 2 groups with every other week. So one client could be every week, another could start with every other week starting 1/1/12 and another every other week starting 1/8/12. The trick is making a fool-proof way to make lists for the every-other week clients. I can't just take every other date, because there could be 2 closures in a row, and would throw all the rest of the list. Seems the only way the do with would be to take the list of dates and test if each date in the list is 14days past the old one, and then keep it. Seem very cumbersome or and difficult to do in Filemaker. Looking like a technique to tackle this. Any ideas? Thanks
  6. I and trying to update an existing system for a school. The school get applications that get stored in the Applications table (one a year per applicant). If approved, basic info is copied over to a Student table and have more detailed data added along with school courses etc. Some student stay year over year, some don't. The school wants to "archive" non-returning students. For later reference or to bring back after a year off. Speaking database-wise there can be a few ways to handle this - but none of them strike me as the best method: -Make a copy of the Students table (called Archived Studnets) and copy old ones out and in as necessary. Seems like poor design (and normalization). -Flag each student record as 'Current' and have a bunch script that only find "Current" students. The problems is that this database doesn't hold the hands of the user. All find tools accessible. Leaving the user to work the database as t hey see fit; having finds/filter constantly seems likely to fail and very cumbersome. -Do away with the Applications/Student and have one database of any typeof "student". Each with a status of App/Current/Old. This method doesn't really hand applications over multiple years (applications a big part of the school) and would seem to have some of the pitfalls of the last method. Would also be a major rework! This seems like a simple and common thing to do, has anyone else tackled anything similar and found a good way to manage it?
  7. Thank you both. For a scanner, I am looking for one that can take some light punishment (will be used in a school). There seems to be a big price break; ~$30ish, then straight to industrial $300+. Some also are USB but only mention be compatible with certain POS system and I am not sure if that means they can be used like a regular USB scanner or not. Would any model that claims to be USB be desktop PC compatible? Any models you have used with success?
  8. I am starting a inventory project that will be using barcodes. Up to this point, I've know barcodes to just be a special font to scan in via scanner, or print out via label printer. My question is what software do I need? I see there is some barcode plug-ins, but I am not sure how they actually help. I assume I need to get a barcode font (for UPC and one for the format of the label printer). I haven't purchased the hardwhere yet so I can not try everything out. Also, in terms of hardware, I am looking for a durable scanner and label printer. Does anyone have any recommendations ? Thanks, E
  9. thanks! I'll try something like that.
  10. Hi guys, I want have a portal with 5 random child records in it. Nothing to fancy, I've come up with a couple ideas on how to do it, but niether really give me that warm fuzzy feeling: 1. Sort the portal on a value list. The value list will a field with randon data in it. Then have the portal only show 5 records. Not sure if that will work nice or not. 2. Have a field in the child records have a random field and sort the portal on it. Again showing 5 records only. The problem is the random field needs to be generated on every record all the time. Anyone got a better way(s)?
  11. Hi there, It seems when I (and users) try to export from a file it freezes Filemaker (v5.5 OSX, host on OSX). It seems only to be from one file with 130,000 records. From what I can tell, it's from file curruption. Changes are the backups have the same curruption and I've read the recover command usually doesnt work (havent tried yet since it will stop work for at a critical time). Does anyone have any fixes to this? I recall this happening a couple years ago, and i managed to fix it, but of course soon forgot how i did it. :
  12. Hi, I'm working on an good old FM 5.5. I made a new button in Photoshop and pasted it in. It shows fine on my computer but it is actully an OLE object. THe FM docs say to use Edit > Object > Links and break the connection there. When i go to this dialog it is empty. I'm all out of ideas. Pasting and Coping it from Paint etc doesnt work either, it always whats the be an OLE object.
  13. thanks! That was too easy. It works great. FileMaker 7 is great.
  14. Hi guys, (I haven't been around much lately, my job as a FileMaker guy came to an end a while back. Now I only dabble in FM for fun now, instead of dishing out cynical and poorly spelt advise). I'm making this DB that generates a random alpha numeric string. This string is then spoken out using the speak() command. I've got that working great. The idea, is that the user then has to sort the numbers and letters by number and by alphabet position (did tha make sense?). For example: sd4f325 should become dfs2345 or 3abd59si9 should become abdis3599 I can't seem to find a good way to generate the correct answer, short of having a case() position() for letter then hardcoding the numbers. I haven't really mastered all that is new and wonderful in FM7 yet, but i bet this could be done. Any ideas?
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.