Filemakernewbie8

Right now I'm creating the fields so I can make any changes with no problem. The text fields I will change them into number fields after I solve this problem with the 26 fields finding the closest number from the target. Some on the numbers do go over the target number. So the Max or Min function won't work for me. The numbers represent points on a line and when the enduser enters a target number, I want Filemaker to spit out the closest point on the line.

I need help to see if a calulation would work but I don't know if creating a script is my only way to accomplish this. Here's my dilemma. Each record in my database has 26 individual text fields that contain a number. Then there's another text field called the "target number" that has a number in it. The question is, how do I create a new calulation field that will select a number out of the 26 individual text fields thats closest to the target number field. Thank You for Taking the Time In Reading My Question.

I'm creating a patient database that will store scanned documents relating to a patient record. Heres what the tables will look like: Patient Table Patient Info Patient ID# (Relationship) Documents Table Patient ID# (Relationship) A Lot of Containers The relationship will be the patient's id#. Now heres the problem, the scanned documents are 200 - 500 pages. Does that mean I have to create 500 container fields to accomodate the documents? I'm planning on creating a portal in the patient table so the enduser can see thumbnails of the documents and when the enduser clicks on that thumbnail, they'll be able to see a larger version of it and print the document. I'm still working on the portal but my main concern is their an easier way to bring in the scanned documents into the documents table?

I tried it. It won't work. Filemaker will overwrite the existing picture in the container.