We have reset all users FileMaker related profile fields. Please take the opportunity to update your information,  this will provide background to members whom read your posts. Click here.

Jump to content

Sam0316

Members
  • Content count

    23
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Sam0316

  • Rank
    member

Profile Information

  • Gender
  1. If i would like to use class table to show the maximum score and the related test date, what should i do?
  2. so i need to delete the existing relationship of the database, right?
  3. Yes.You are right so i need to create a join table of class line item to test history table?
  4. Yes. but the user would like to have a report with class A or Class B, not both
  5. A student could enroll in different classes test is not specific to any class students could take for more than once for same test students could take test as they wish
  6. Thank you. Actually, my client would like to have a report like Class A Student Name Age Date of Birth Maths Score English Score Peter 12 1992/4/6 60 70 Jenny 13 1991/3/8 70 50 And the score is the maximum score that the student get of all the test the student attended. A student could get a test for many times, so i use a portal to present all the test detail of a student. Is it better to have a summary report to present this data? i should find the record with same class rather than present them in portal?
  7. Thank you. so i need to delete the class and test table?
  8. Thank you. i have read the filemaker training series(beginner and advanced), several forums and videoes. anyway, thank you for your advice. Is it a good idea to directly connect student to test history table?
  9. Thank you. so you mean i should reading some books? what books you will suggest? i should create a new relationship of test history and class item table?
  10. Hello everyone, i am new to filemaker. i am now working on student database. The following is the problem i face. The relationship of my database is shown as follows student >> Class >> Class Line Item(portal) , student>>test>>test history(portal) so in the class layout user could see details of a class. In the test layout, user could find out the test history of a student. My client now would like to have a report based on the class line item showing the highest score of the student. But my original idea is to separate the table clearly as shown above. i try to make a portal based on class line item table, but there is no relationship between class line item and test history table so i could not show any related data of the student. For the highest score, i think i will create a summary field to calculate the maximum value of the score. my question is should i write a script to take the highest score of a student from the test history table to class line item table or modify the relationship between these tables?
  11. Invoice Database Report Presentation

    Thank you. so you mean i should have a data entry layout first and then go to report layout and data sorted by food? so the data should be specific to that customer? right
  12. Hello everyone, i am new to filemaker. I am developing an invoice database. Here is the situation. My idea is creating 4 tables. Invoice table, invoice line item table, line items details table and a client's table. the relationship are invoice-->invoice line item, client-->invoice, invoice line item<-- line item details table. The layout should be something like the attachment. The most difficult thing is the description part. The invoice template of the client divide the description into several parts, for example, part one, part two and part three. For example Part one fruit apple 4 50 orange 5 60 Part two Meats chicken 10 100 beef 2 50 My question is how could i present the data in this way, i have considered using portal, but one problem is if i use conditional value list it might present like fruit apple 4 50 fruit orange 5 60 meat chicken 10 100 meat beef 2 50 fruit, meat, apple are store in the line item details table. so it may not be the layout the client's want. Then i have another idea, so i need to have a summary report. The portal could be the data entry page. I need to create another layout for the reporting. then the report should be based on 1 client and using food catagory as the break field to present the data. I am wondering is there any good method to present my data?
  13. Portal from 4 tables

    If i combine them into one table, i need to create 4 layouts using same table with corresponding fields. But one problem is the school table links to other table for other application.
  14. Creation of flexible form in filemaker

    Thank you. May be my description is not clear enough. my client would like to print this form out or save as pdf so they don't prefer scroll bar in text field. The subtitle box(sports/music/clubs) also requires sliding or hiding.
  15. Portal from 4 tables

    Thank you. There are other information store in school and university respectively.For example, email, contact, system, organisation etc. On the other hand, the university store the undergradrate population, GPA, interview policy, etc. so in this case, is that ok to combine them into one. As number of records increase annually, will it be difficult to manage the data?
×

Important Information

By using this site, you agree to our Guidelines.