This content has been marked as final. Show 4 replies
just my input after tried many way.
this cannot be done. So what I did is after execute_query return data, I create 1 button for user to click then trigger 'WHEN-BUTTON-PRESS' will fetch another set of record append to them. no automatic solution in 1 shot.
HI1 person found this helpful
As per your notes, it seems that both query/structure having same structure, if so , for both query - create new view based on both query(single query) - so that user will get data on single trip/way,
Hope it will help u
Edited by: O.Developer on Dec 19, 2012 8:44 AM
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
Yes You are correct1 person found this helpful
In this case your way of doing is okay.