What relationships do you have between these tables?
On what table is your layout based when you click to run this script?
I am on a Fiche Planif based Layout. Currently there is no relationship as this is one table. I realize that I need to add a Field Theme_ID to the table Fiche Planif that you see on the screenshot. Then Create another table looking like this:
Fiche Planif List Table:
My Relationship would be to link Theme_ID from "Fiche Planif List" Table and Theme_ID from "Fiche Planif Table". Then I would create a portal to display related records? Am I correct?
The thing is I would like to have the result but by using the buttons on the Layout and not using a portal. Any way to do this?
I am on a Fiche Planif based Layout
Since there is no table named "Planif" shown in your first screen shot, I can't tell to what table a table occurrence named "Fiche Planif" might refer to.
Currently there is no relationship as this is one table.
Your first screen shot shows 7 different tables. None use the name "planif".
I really can't tell enough about your database to answer your questions. It's possible that you need a button click to perform a scripted find, but I could very, very easily be wrong.
You may find this thread of scripted find examples helpful: Scripted Find Examples
I am sorry for being unclear. My previous screenshot shows the field of the Table "Fiche Planif". There are 7 fields but it's the same table.
I have made changes to the database. Please find the details below:
1st Table = List Get Informed:
2nd Table = Fiche Planif
Contenu_ID (Means Content_ID)
Contenu_Titre (Means Content_Title)
Contenu_Details (Means Content_Details)
On my Layout , the buttons you can see are the different possible values for Get Informed_Theme. For each theme there are 1 or many Content_Details therefore Content_Title 7 Content_ID. What I am trying to do is to display the content related to Get Informed_Theme when clicking on the button. I have created this relationship in order to be able to use portals but since portals cannot be displayed in a tab control format, is there a way to display the details using script steps and OnObjectKeystroke trigger maybe?
therefore Content_Title 7 Content_ID.
What does that mean?
What I am trying to do is to display the content related to Get Informed_Theme when clicking on the button.
And in what fields does that content reside?
but since portals cannot be displayed in a tab control format,
This is not the case. I put portals inside tab panels all the time.
yes, but what does the number seven in "Content_Title 7 Content_ID." mean? Perhaps that is an error in typing your original comment.
Yes, sorry the 7 is typing error. Please consider the latest msge & screenshots as the most accurate one.
Yes, but given that you can put a portal into your tab control, what do you want to do next? There is more than one option now before you.
I am not sure what is the best practice in these cases. I don't mind using the Portal , could you walk me through the integration of a portal in a Tab Control ? . Also, Is it possible to display dynamic fields in the tab labels ("Avant la visite", "Bien s'orienter dans le Palais"....) these are values from the Contenu_Title field.
I am really sorry for the back and forth caused by my unclear expalanations.
Yes and much remains unclear.
To put a portal on the panel of a tab control is simply done by:
Enter layout mode
Click the portal tool in the status tool bar
Drag with the mouse to draw a rectangle inside the tab panel where you want a portal.
Select the options for the portal that you want from the dialogs that appear.
Ok . Are the following script steps (see screenshot) accurate if I want to have the same results using scripts. This is not the actual script as the Set Fields would be different.