Try making 4 value lists, each with one value.
The example above was just an example to explain it simply. I actually have over 15 values in the value list and also the value list is built from another field input so would like to keep them together.
A more detailed description of what you are trying to do would be very helpful.
Conditional value lists can select which values are used in a value list from a larger set of values drawn from a table. That might be one way to make this work.
There are also ways to put layout text on your layout set up as buttons and with conditional formatting so that they look and function like check boxes, but actually perform scripts that modify the data. And the data modified can be individual records in a table of related records---which could then be listed as rows in your portal.
But to be more specific than that requires a much more detailed understanding of what you are trying to do. What is not clear at this point is how "over 15 values" gets filtered down to just 4--one for each corner of your square.
I'll try what you suggested Phil shortly but this is what I want to do. Btw, I sent you an internal message with even more detail of this and other issues.
On a layout, have an outline of a vessel and around this vessel I would like to have single checkboxes based on the equipment list (value list) that has been created (from the thread http://forums.filemaker.com/posts/6dd616be93?page=2). So for example, have a single checkbox for the Main Engine Port, then another single checkbox for the Bow Thruster. For the moment, I am only able to create a field for the entire equipment value list, not just a single piece of equipment. It's more or less for aesthetic value, as I would settle for just the entire list if what I am asking can't be done.
Yes, but what determines that a check box will represent the Bow thruster and not the Main Engine Port? There has to be some sort of value there that FileMaker can use to determine what value to assign to that check box when it is clicked.
Question: Is this to show the approximate position of a given item of equipment on the Vessel's equipment List?
I'm trying to imagine what you are trying to achieve.
You could have a relationship to a table that has two fields - the Equipment Description (I am assuming the Equipment ID as A Given) and the equipment location. Then place a portal at each point of the diagramatic vessel. Filter each portal by 'Location', where the portal you place over the bow is filtered to only show records for that Vessel (ID), that Location, etc.
To answer your reply Phil, that is my question. Is it possible to have a single checkbox showing one value from a value list when that value list has say 15 values in it.
Answer: Yes you are right in what I am trying to do. I would like to have a checkbox at each point on the vessel where a piece of equipment is. (This list has been created from the equipment layout and thus is already in the equipment_list value list). From there, the user can select by checking checkboxes, which equipment they want to include in the equipment list they are building for that vessel.
Sorbsbuster, I already have that table setup which Phil suggested previously in another post (http://forums.filemaker.com/posts/6dd616be93). This is my current structure:
Another advantage of making it a number of portals showing records from a separate table is that you can then sort the list of equipment many different and, I'd have thought useful, ways. For example:
One vessel needs:
HMS Golden Hind
Generator (Large) x 2
Generator (Medium) x 3
Bilge Pump x 4
Search lamp x 1
Each type of equipment is needed:
HMS Golden Hind x 2
RMS Titanic x 4
SS Queen Mary x 6
Similar locations need:
Needed at the Bow
HMS Golden Hind
SS Queen Mary
Needed at the Stern
SS King Orry
Is it possible to have a single checkbox showing one value from a value list when that value list has say 15 values in it.
I don't think you understood my question.
You have that single check box on your screen. Your equipment_list for this vessel includes a "bow thruster" and a "winch". How do we know that that single check box represents the bow thruster and not the winch?
I was hoping it would be something similar to the standard setup of a value list with checkboxes, checkboxes with the respective equipment names next to it (see screenshot). All I would like is the have each individual checkbox with equipment name spread around the vessel image at their respective locations on the vessel.
All good, but how will you Select, say, the Bow as the location for a specific piece of equipment?
Sorbusters portal suggestion is looking better and better, but you still need a way to indicate that the "Deck Crane" for example is located at the stern and not the bow or vice versa. You could, for example, have a field in Equipment_List that identifies the general location for that piece of equipment. Then the portals could filter to show only Equipment_list records for items with a specified location in that spot.
This would then be much like that map of the dock slips showing vessels at each location that we discussed in another thread.
Ok thanks. I'm working my way through this. Can someone help me with the second part of the original question relating to checkboxes and the portal?
What I would like is that once I have checked the equipment in the checkboxes, I go to another layout that has a portal that displays all the pieces of equipment I checked on the previous layout. I've have done this with the _fkEquipmentID field, however, all of the equipment checked comes into the portal in the first row, i.e. each piece of equipment is NOT on a seperate row. How do I display each piece of equipment on each row of that portal?
FYI, the layout is based on the "Vessel" table and portal linked to the "Equipment_List" table.
You need to be creating a new record in equipment list each time you add an item to that list. A single field with multiple checkboxes won't work for that purpose. Buttons that perform a script, on the other hand, can add that new related record each time you click to select an item of equipment AND specify its general location.
Thanks Phil. I'm understanding what you are saying but how would the script look like to create a record each time I click to select an item? Do you mean when I am selecting the pieces of equipment in the checkboxes?