This content has been marked as final. Show 4 replies
thanks O.developer. That's another solution I tried
Even if 2 portion recordset can sharing the same structure which I can create in single view. But my problem is my second part of new record set is using where cause which is primary is not database item. for example
:BLK1 have 4 item. item 1,2,3 is DB column=Y and item 4 is none database.
I tried create view and execute_query return
1st record return from query using where cause item 1 = '1001'
2nd record is another using where cause item 4 = 'ABC'
when I commit form. the 2nd recordset thrown error like primary key issue in database block. Can you advice this?
Edited by: Jarjarbank on Dec 18, 2012 11:58 PM