AnsweredAssumed Answered

How to select records from one table and link them to a record in another table ?

Question asked by noel_ferron@msn.com on Oct 14, 2011
Latest reply on Oct 14, 2011 by noel_ferron@msn.com

Title

How to select records from one table and link them to a record in another table ?

Post

 

Hi,

I am a newcomer working with FM Pro Advanced V11.3 and I need advices to solve the following problems:

  • My table "T_Objects" contains a few thousands records.
  • It is linked thru a Join_Table to the table "T_Attributes" which also contains a few thousands records in a Many-To-Many relationship.
  • A table occurrence "T_Attributes_Not_Linked" shows  attributes that are not linked to an object.
  • Each attribute is of one "Category" received from a list of values.
  • My layout "L_Objects" is used to update the records in T_Objects, and it has a first portal showing all attributes linked to a given object.
  • I have created a second portal in order to see all attributes from "T_Attributes_Not_Linked" for that object.
  • When I create a new object in "T_Objects", I would like to be able to choose from that second portal, the attributes that I want to link to my new object.
  • Hopefully, without having to scroll-down all these attributes one by one...

Here are my questions:

  1. How can I set a filter in my second portal in order to see only those attributes that correspond to a specified category ?
  2. Is it possible to list in that second portal the attributes with "Check Boxes" so that the selected ones will create records in the Join_Table ?

Any suggestion will be welcome.

Outcomes