Jump to content

wyth

Newbies
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About wyth

  • Rank
    newbie
  1. Hi all, I'm running FM Pro 7 for a small office at a university writing center. We use FM to enter student and session records. Last year we started publishing our database to the web so tutors could enter records from our satellite locations. All was fine until just recently, when anyone who tries to connect to the web-published database from a wireless connection can't get in. In fact, they get nothing at all, not an error, just a blank page. However, access via a web page is still available via a wired connection. So a tutor can't log into the database via the published web page through a wireless laptop, but that tutor can plug in an ethernet cable and enter records as normal. I've been on the line with our IT, to no avail (our university's IT dept. doesn't support FM). We have a clinic coming up and need to be able to enter records remotely. Any ideas?
  2. Okay, this is my first time here. I've been searching for an answer to my problem for about 6 hours, and now I'm posting. I'm working with a database of students for a university writing center. I didn't build the database, but it's what we have to use. Each semester gets a new database, and each database has two tables, one for student records and one for session records. Each student gets one student record of basic info, and each student gets a session record for each time they come into the writing center for a tutorial. We track primarily through email addresses. Once you enter a student record, the ID fields of both tables are linked, so when you start to enter a session record, it auto fills much of the data. This means that Student X will have one student record, but maybe seven session records. We'll get around 1000 session records a semester. BUT here's what I'm trying to do. I want to show a count on both the student records and the session records of how many appointments each student has had. The only way I can see to track that is through the ID's that we use (a mix of letters and numbers -- a text field, not numerical). I'd like to have the number of sessions show because each student is limited to a certain number of sessions, and we have had people try to game the system in the past. I'd like it to just show up in a field that reads "Session #_____" but I can't find how to do it. I've tried using Count, but I keep getting the same results -- I don't get a count for a specific ID, only of all the records in that table. That's not what I need. And I don't want to do it as a report; the desk staff won't be running reports, we get very busy, and I want the desk staff to be able to just see how many appointments someone has had. I'm fairly new to FileMaker, but I'm a fast study. We're using FileMaker Pro 7. Is this a real simple thing that I'm just not getting?
×
×
  • Create New...

Important Information

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