AnsweredAssumed Answered

trouble relating through a join table

Question asked by actnow on Feb 4, 2010
Latest reply on Feb 5, 2010 by philmodjunk

Title

trouble relating through a join table

Post

Hi,

I've searched through the forums and spent some time in the Knowledge base, but can't seem to figure out this issue.  Apologies.

 

I'm using FMP10, on Windows 7.

 

My table naming convention is the following:

(T20b_role_GAMES|id_game)

 

T20b   - Role table # is 20, b indicates that it is the 2nd instance of the table

role     - table that this instance is assigned to

GAMES - the data source of the Table

id_game - the field that relates the role table to the Games table

 

 

Tables involved:

Games

Contact

Role (join)

  • id_contact
  • id_game
  • id_role
  • Name_Contact
  • Name_Game           Indexed, Lookup (T20b_role_GAMES|id_game)
  • Name_Role             value list

 

Table instances

T20a_role_CONTACTS|id_contact

T20b_role_GAMES|id_games

 

T05p_contacts_ROLE|id_contact

T15g_games_ROLE|id_games

 

 

From a Games layout, I have a secondary tab with a ROLE portal (T15g_games_ROLES|id_role)

  • joined by role_id
  • Records can be created by this relationship
  • Fields are Name_Role and Name_Contact
  •          Both are value lists from the join table (T15g_games_ROLES|id_role)

 

To enter a new row in my portal, I select the Name_Role & Name_Contact from the drop-downs

 

When I look at the Role Layout, a new record is created

All fields are filled in EXCEPT the contact_id

 

I need to figure out how to get the contact_id filled in so that the secondary tab with a ROLE portal will show in the Contacts layout.

 

I've confused myself with lookup fields and adding another instance of a table to my joins.  Now I've muddied any possible clear solution.

 

Any help would be very appreciated!

 

Thanks in advance!

 

 

Outcomes