Jump to content

Regulatory Affairs

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Regulatory Affairs

  • Rank
  1. Just wanted to say that the advice gaven a couple months ago is still useful. It's helped me out of a dilemna. Thanks.
  2. How can I Find records that have a blank in the Committee Action field? The only values for the field are either Admitted or Rejected. Records for which no action has yet been taken are blank. I've tried =" ", ="", = . I wasn't able to do it on a layout either. For another report I want to list applications received since the last review date, which the user would input when running the script. The script I've written runs correctly, but I want to limit it to those with a File Started Date greater than a date from the user. Thanks bunches!!!
  3. I see it now. Thanks one and all. You've been a great help.
  4. The layout as is has the "Missing Documents" field large enough for more than one line of text. This leaves blank space below the data in the other fields. If I decrease the size of the "Missing Documents" field, the blank spaces are gone, but the "Missing Documents" field doesn't display all the data. Is there anyway to only expand the line of data if the "Missing Documents" field needs the space?
  5. Go to Reports and click the Application Status button. The field "Missing Documents" should grow and shrink based on the data per student's record.
  6. I'm trying to create a report and am not using a portal. Should I be? I'm familiar with how queries and reports are done in MS Access and am learning the script writing of FM, but I can't determine how to link a script to a layout/report. The only way I know is in the create a report wizard. I've attached a zip file of my database as is. Once again, any help is appreciated. Reg-Affs.zip
  7. I've enlarged the field object to display three lines of text (the most it would ever hold) and set the Sliding/Printing to Sliding up based on All above and also checked the Also reduce the size of the enclosing part. Each record still displays the field with space for three lines of text, whether there's any data or not. What am I missing?:
  8. I am used to working with MS Access and can put together a report with fields that grow as necessary easily. However, working with FileMaker 8's "sliding" has me stumped. I want to make a report from a student database that includes the students name, status and comments. The comments field can have a lot of data or very little to none. I've tried numerous combinations of the sliding up options and nothing works. The only way I can see all the text in the comments field is to enlarge the field object. Any help would be appreciated!!!
  9. That was it. Thanks alot, Steven. Have a good day.
  10. This forum has been a life-saver for me on this temp job. Thanks for taking the time to share your experience and knowledge of the software. I have password-protected a database, using the Admin account. When I set up the protection several weeks ago, I tested it and it worked. Now, however, I'm no longer asked for a password. Is Filemaker saving the login info on each computer? If so, is there someway to undo that?
  11. Thanks for the help. It takes care of the display problem, but I still have a problem creating a new record of a course for a student. I'm open to suggestions.
  12. I've created the table to join the student and course info (Student-Course Join), but am having a problem displaying and creating records. I have a form layout called Academic Info that should display the current student's courses, whether completed or not, in a portal. The fake data I'm using has one student with two courses, but they are displayed as two records on the layout, not two in the portal. While on the Academic Info layout, Ctrl N creates a new record in the Student-Course Join table. I enter a Student Record ID, hit enter, and the correct name appears, but the portal f
  13. That sounds like it will work. Thanks for your help...and so quickly. Have a great day!
  14. I'm creating a database to track student info, courses, grades, etc. In designing the tables, it appears a have three tables that relate to each other: students, courses (course & semester) and grades. Each student can have multiple courses and vice versa. Each student can have multiple grades, one for each course. I think I need a join table for the student - course many to many relationship, but am not sure what to do with the grades table. Any ideas?
  • Create New...

Important Information

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