This doesn't look like a practical way to set this up. "over 50 check boxes" does not seem easy to set up nor flexible when it comes time to add/remove items from that group of check boxes.
I recommend 3 tables implementing a many to many relationship where you currently have two tables.
Manufacturers. One record for each manufacturer with __pkMfdID as an auto-entered serial number to identify each company
Products. One record for each product with a manufacturer with __pkProductID to identify each product
Manufacturers::__pkMfdID = Manufacturer_Product::_fkMfdID
Products::__pkProductID = Manufacturer_Product::_fkMfdID
To link a given product to a given manufacturer, you create a record in Manufacturer_Product with _fk fields set to link it the correct Manufacturer and Product records.
Note: This assumes that one product needs to be linked to many manufacturers. If this is not the case, no 3rd (Join) table is needed in order to link a product to its manufacturer.
Hi , thanks for the answer, however I am looking for something different but obviously was useful.
I would like to select the 2nd category (RED frame) and in the Manufacturer pop-up menu only those titles/items should be appeared than under the title of the 2nd category. So in this case I selected the Computer category and I want to see only those companies that already checked under the Computer field (Manufacture 1, Manufacture 3). But, If the selected category is not Computer but TV everything would be changed dynamically and get only titles that is under TV field (Manufacture 3 only) (upper drawing).
Then you are describing a conditional value list where the selected categories filter the list of manufacturers.
Here are some links on the subject:
There's a lot of overlap between the first two links so you can read one and skim the other. The demo file gives you several examples of different conditional value lists so you can examine them to see how they are set up. If you are using FileMaker 12 or later, you can open this demo file from your File menu to get a converted copy of the demo file that you can examine in your version of FileMaker.
The next to last link discusses how to set up a chain of conditional value lists where the value selected in each conditional value list controls the values listed in the next value list and the very last link is a fairly new addition that describes how to use ExecuteSQL to produce conditional value lists that aren't easily possible with the other methods described here.
Forum Tutorial: Custom Value List?
Knowledgebase article: http://help.filemaker.com/app/answers/detail/a_id/5833/kw/conditional%20value%20list
Hierarchical Conditional Value lists: Conditional Value List Question
Using ExecuteSQL to produce a conditional value list: Using ExecuteSQL to Produce a Conditional Value List
Feel free to post follow up questions here if those links aren't enough to get your value lists working correctly.
Thanks for your reply. Well this way I got a huge topic it seems so I need some days to study and digest. There are many related conceptions that need to be clear to understand. I will be come back for sure. Also I downloaded the files and there are many new great things there!
I am just thinking there could be many way to get same result. Let's start on one.
In my example using conditional value via simple method of FM tutorial "Value and Data table using Type connection" is clear. However this situation is a little bit different.
When I want to select Manufacturers from the pop-up menu actually I do not want to use the same method as in FM "conditional values" tutorial. I think I am looking for something IF logical operation. IF I select specific record from category list, please provide me the right Manufacturers from XY field from TableZ. This is kind of a dynamic navigation.
If I follow the tutorial I need to create a lot of Manufacturer records because one Company produces more category of products, so this would be a lot of work. So that would be easier to use some checkboxes for each Manufacturer and I fill the right boxes relating to the Manufacturer profile. After somehow this would be filtered by the pop-up menu. And filter would be set by a category record eg. Computer or TV. ...no idea.
...I am on youtube at the moment :) with guy stevens' related tables with conditional values.