Jump to content

How to implement a portal of buttons related to field types

This topic is 2809 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Greetings FM community and thank you for your time


Here's a newbie question from someone who really wants to learn!


On a "sales" layout, that's associated with a "sales" table, I'd like to have a portal on the left that displays the "types" (table) of "products" (table) available. For instance, "shakes", "bars", or "items". 


Each product has a type, and depending on the selected button in the first portal of the sales layout, I'd like to display the products of this type in a second portal, located beside the first portal. For now, not much success, but I suspect it's the relationships that are wrong. 


Any help helps!


Thanks in advance




Link to comment
Share on other sites

IMHO, your relationships need to look more like this:




A portal to AllProductTypes, placed on a layout of Sales, will show all product types (note the x relational operator). If you place a button in this portal, that populates the global gProductTypeID filed by the selected product type's ID:

Set Field [ Sales::gProductTypeID ; AllProductTypes::ProductTypeID ]

then a portal to Products 2 will show all products in the selected type.

  • Like 1
Link to comment
Share on other sites

It works! With a lot of help from my friends.

Thank you so much, I would never thought it that way. The relational X is key, and I presume "sales" in your example is what is called a join table?

Once again, thank you very much for the time you invested in my education. Very formative!

Link to comment
Share on other sites

This topic is 2809 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.