What version of FileMaker are you using? (Options for controlling how the field highlight works have changed in recent releases.)
From what I see, you appear to have set up either repeating fields with the repetitions arranged vertically, or a great many individual fields, arranged in rows and columns. Neither approach would appear to be the optimum design for your data, a related table of records shown in a portal would be more flexible in most cases. But which design option did you use in setting this up?
Thanks for the reply PhilModJunk.
I have FileMaker Pro 13. I do not know the software too much, I watched a few tutorials and attempted to do what I imagined. I think I used repeating fields vertically. I didn't use any design options, I created a database, tables, and starting adding fields.
I don't really know how to create related table of records shown in a portal to be honest… I'm informing myself as best as I can, but it seems a bit complex as I've seen that programing and scripts are often involved, and I'm ignorant of both, I though the software was a bit easier at first...
I didn't use any design options,
But you did. Either you used repeating fields or you did not. Those are what I meant by design options.
Can you post a screen shot of your layout taken while in layout mode? I should be able to tell from that image whether or not you used repeating fields.
Either way, a portal to a related table of records will be a much better way to set up your database than whichever method you have used here.
I'm informing myself as best as I can
There are quite a few training resources available if you search for them, including this one which is free from FileMaker: https://itunes.apple.com/us/book/filemaker-training-series/id787527886?mt=11
And we'll be glad to answer questions here, but a forum is best suited for answering specific questions such as you asked here while the tutorials, books, youtube videos etc provide more a broad based foundation of understanding form which to work.
I though the software was a bit easier at first...
The interface design for FileMaker does make it easy to get started, but the concepts involved--the correct design of a relational database system can be anything but simple. So if you move even a little bit beyond just a very simple single table database, you'll find yourself needing to learn quite a few new concepts on how to get this type of thing to work.
Ok, so I guess I did use repeating fields as design options. I'm gonna post a screen shot. Thank you for the help and the link, I'll check it out.
Yes, those are repeating fields with 12 repetitions specified for this layout. I recommend that you change your design to use a portal to a related table fo these records instead.
I've been playing with an auto-enter calculation that would enter a different value into each repetition of the Edition field, but it isn't working. You could replace the field with layout text that has these values. You could set up a script that creates the new record and then loops through these repetitions in order to assign the values you want to see to each repetition.
I have to figure out what a "portal to a related table" is.
I kinda get your concept, I just have to figure out how to do all this, I have no idea how to write a script or the language used, etc…
Not as easy as I thought… Thank you for your help though.
"portal" is a term that you can look up in FileMaker Help or in any training materials that you have acquired for learning how to create Filemaker Databases. The user interface can make getting started with your database seem very easy, but since relational database concepts can be anything but simple, you can easily be confronted by concepts completely new to you very quickly.