AnsweredAssumed Answered

Value List acting weird.  Can any of you 'brainiacs' help me?

Question asked by synergy46 on Jun 29, 2009
Latest reply on Jul 2, 2009 by synergy46

Title

Value List acting weird.  Can any of you 'brainiacs' help me?

Post

I have been wrestling with this one for weeks.  I have looked at it from the view point of relationships and checked the constructs of my value lists.  It is just weird and it driving me nuts.

 

 

There are two problems:

#1) The Many table (optionTransactions) is setup to get the OptionTransactions::optionid.fk value from Options::optionId.pk and Options::optsymbol.  It should return the optsymbol.  Instead it returns the OPTIONS::optionID.pk value.  When I click the same value a 2nd time, it finally gives me the Options::optsymbol I expected all along.  

 

#2) With each OptionTransactions new record, a new record is added to Options.  Even if I turn off 'add records' in the relationship, this happens.  Why?

 

Please take a look at give me your thoughts:  Click Here

Outcomes