Value List acting weird. Can any of you 'brainiacs' help me?
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