February 5, 200223 yr These are very basic and dumb questions. 1-How do I get a pop_up list to select an item when I type the first one or two letters. 2- I have two screens in two different files, say one is class and one is students. When I enter the student information (name, number etc...) in the student screen and switch to the class screen, how do I get the class screen to remember the student number and display it instead of me entering it again. Thank you and sorry if this waste your time. Also can someone point me to some online resources where I can research these sorts of things.
February 5, 200223 yr 1. Type the first one or two letters, then hit the Enter or Return key. Bonus: Hit the Esc key if you want to type something else altogether. 2. The old way to do this was to make a script in one file to copy the number, which would then call a script in the other file to paste it. The new improved way is to define a "constant" field in all your files, either a calculated field that = 1, or a number field that auto-enters 1. Then you define a Relationship from one file to the other based on this constant field. This has numerous applications, (e.g. a portal that shows all records in other files, or the same file) -- but in your case you can use it to make a script in the Student file: Set Field [Class by Constant::StudentID, StudentID]
February 6, 200223 yr Dukude: There are only a few good online resources for FileMaker. I would say that FileMaker.com is very useful. Other than that, this forum has proven to be my most precious online resource personally. The vast wealth of helpful knowledge in these forums has helped me with all my problems. The MacAcademy and WindowsAcademy series of CD-ROMs and seminars are also very helpful (and also expensive). Good Luck Ken
Create an account or sign in to comment