10.1.2 form problem querying master details with underscore
ngac_rApr 21 2010 — edited Apr 28 2010I have a problem on a form we have were by the user is querying a record and the detail block is bringing through an incorrect record. This occurs on all records that have an underscore "_"
The form is huge so i am trying to cut down whilst testing but thought i would ask the question to see if its anything obvious.
basically there are 3 tables all on there own blocks linked by the built in relationships in forms.
the user queries the top one and the other 2 are set to auto query.
the problem is with only one primary key that is referenced. This has an underscore in it.
i.e user brings in top level "1000_0"
this brings through on all detail records another primary key which is "1000-0" but the top level shows the correct "1000_0".
Is anyone aware of anything this may be, iwill endeavor to set some testing up.