AnsweredAssumed Answered

Getting value from Relationship

Question asked by MattLeach on Jan 19, 2015
Latest reply on Jan 19, 2015 by MattLeach

Im helping a friend out with a database and am stuck on pulling a value from a relationship.

 

What I am trying to accomplish is having a one to many relationship using a Join Table

 

Lets say I have Widgets, Join, and Categories. My relationship is setup as follows:

 

Widgets::_pk_ID = Join::_fk_WidgetID and Join::_fk_CatID = Categories::_pk_ID

 

I also have a TO called Categories_List which is a TO of Categories table. This is related to Widgets with a constant.

Widgets::zz_Constant = Categories_List::zz_Constant.

 

There is a value list that contains a list of all the categories

 

In the database on the Widgets table I have a field that utilizes the value list of categories.

 

The way it is setup is you click a dropdown and select the category you want and click a button to add the category to the record. This creates a record in the join table with the Widget ID and the ID of the category.

 

The issue I am running into is that no matter which category I select, the ID for the category is always 1 for the first record.

 

I have tried capturing the category id from Categories::_pk_CatID as well as Categories_List::_pk_CatID but not matter which category I select, it's always 1

 

Im sure I am overlooking something simple but I just cant seem to pinpoint it.

 

Thanks for any help you can offer

Outcomes