![]() That's the portal view, so you can see what is going on. Now the portal shows RED and YELLOW, as it filtered the records to only show the ones that had CAR in the object field. And put a portal on the layout, that displays COLOR from the child table. Relate that global to the OBJECT field the child table. Now in another global field (g_object), set that value to "CAR". ![]() SO, let's say you select the second record - the one that has CAR in the object field. So fields from this child table, shown on a layout (most likely in a portal, so that the MANY side can be shown), and displaying the field OBJECT (from that table occurrence specifically), would show Couch, Car, and Potato. The RED in the child table, is a field called "Color" and the second field, Object.īy relating the global to the color field, and setting the global to RED, the relationship filters the child table to only display the matching record. In this setup, the RED on the left, is in the parent table - the one side of the relationship - and is a global field (all record with the same value). The same child table can be shown in a portal simultaneously, where it would show the subset of data that matches the selected conditions. Then you would have 5 global fields, each relationship matched against the respective field in the child table to product the set of popup value list items.Īs you pick one, or more, it filters the next to be the subset that matches the conditions. It would be like a flat file - a spreadsheet, as it were. ![]() In the case of what you have, I might suggest a single parts table, made of the fields SERIES, TYPE, SIZE, PARTS, and PRODUCT ID. The way you get there in FM, is create alias tables, called Table Occurrences (TO). In the parent table, you set a global field that relates to the category field in the child table, and the child table is thus filtered to only show those records that meet the match condition, in this case, category. ![]() OK, the way a conditional value list works, is that the child table has a category field that groups the set of unique items accordingly. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |