Noobs here. I am looking for some assistance that when I select a record on a form I am taken to that record. Example below.
I am taking this simplified hypothetical example in the parts table with columns: Finished, Shared1, Shared2, Shared3
Row 1 values: A, B, C, D
Row 2 values: B, A, C, D
When Row 1 loads in the layout you sent, say that A appears on the upper right box. Therefore B,C, D load in the bottom in red
Desired behavior: when B is then clicked, you want it to replace A in the upper right box and have A, C, D appear in the bottom in red.
Thanks in advance,
By Greg Hains
Once again I find myself stumbling over something that I think will turn out to be very simple. I seek the help of our Filemaker mentors for assistance.
I have a table with about 3000 records in it.
One of the fields is called "Type" and can contain any one of 7 different values"
Another field is "Gender" (containing one of there values: Male, Female, Unstated")
Another field ("Duration") is a numeric value that can be anything from 0 to 300
I want to Find records whose Gender is male (easy), the numeric value in a range (also easy), but exclude all records whose Type does NOT equal "Assessment". I found that I can Omit the "Assessment" records OK, but then unable to then constrain the set to show just Gender=Male and a Duration value of choice. After the Omit works, running a Find on the remaining records seems to undo the Omit. So, I tried the Omit stage after the Find of Gender and Duration - still no luck. It seems that a Find cancels out a previous Omit.
One cannot do a Find on something that "does not equal" - it has to be an omit process. I am not going to do a Find on the other possible 6 values either - thats not a clean solution.
I have been unable to find a solution through Googling on the correct procedure and usage of the Find/Omit tools to achieve what needs to be done. I'm sure it can be done, and I'm just missing something simple.
Any help would be appreciated.
I have a form in which users make measurements of multiple parts, then input the max and min measurements. I then have conditional formatting that compares these maxes and mins to the hard mins and maxes for that part. If the inputted max is larger than the hard max, or the inputted min is smaller than the hard min; the conditional formatting is supposed to highlight that measurement in red. This has worked in almost every case I have tested so far, except for one strange case. I have a hard min of 9.8, and my user is attempting to input 10 as the min. FileMaker is highlighting this in red, even though 10 is larger than 9.8. When we change it 9.9 it isn't red, but 10.1 makes it red as well. I have no idea why this is happening, so any assistance in this matter will be greatly appreciated!
Would appreciate your help. I have a database for a university, basically I have students that enroll to a subject and can either : win, homologate, fail, or cancel the subject.
I must make a report that shows every student that has failed, canceled or hasn't seen certain subject. The catch is that if the student has seen the subject two or more times and for example the first time he failed it but the second time he won it, that student appears on the report even though he shouldn't because he won the subject on a second try.
So, how can I make a report that excludes a student that has enrolled a subject more than one time and has failed and won that same subject?
I am building a custom solution for my company that tries to replicate the functionality people are used to in a series of text-based documents. One of the things I have been asked to produce is a method for highlighting specific text on screen when viewing historic log notes. In some cases, we have decades of notes for a customer, so simply looking through those records is impractical, and the users want to be able to view the found note in the context of other notes, chronologically, so I can't just have them perform a find for the specific text.
Is there a way to jump to the specific row of a portal that contains a specific text string without actually filtering the portal results?
I am using Filemaker Pro 15 on Windows 7.