[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Multi-Table window - master/detail (AREV Specific) ====
=== At 19 JUN 2001 12:11:23PM Raju Tamrakar wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
I have a master/detail (one-to-many) two table window for master info and a detail info. Similar to sample window eg in AREV Sample application. My line items on the detail section of the window which is just displaying detail info. for the master record.

 my file layout:



TICKET (master)                  TICKET_DETAIL (Detail file)

-------------------------------------------------------

Ticket_NO (KEY)                  Ticket_No (KEY part 1)

other fields                     Line_Item (KEY part 2)



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~





Window format:

------------------------------------------------------------------

   Ticket No ----

other fields ----

 ...............................................................

Line_item        other data

 --1--                 ----

 --2--                 ----

 --3--                 ----

------------------------------------------------------------------



My bug or problem is the line_item display stays in sequence i.e. 1,2,3,4 for a while then after an update to the record the sorting goes out of sync eg. 2,4,5,3,1 as if I entered randomly. Again I am entering the details, line item no first then other details. Line Items stays in sequence for some time until I do something to the record (update) at a later time. How can I keep them in sequence as I entered.  Any suggestions would be greatly appreciated.

TIA

Raju Tamrakar

raju_tamrakar@yahoo.com
</QUOTE>
----

=== At 19 JUN 2001 05:17PM Raju Tamrakar wrote:  ===

<QUOTE>I have been able to get the detail sorted by the line_item using a QUICKDEX ing on the detail table; but, that binds me to the 64K chain later; any other suggestion? shouldn't line_item entries stay the way they were entered or does MT WINDOW gets populated in some way that I am not aware of.

TIA to All



Raju T.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=319BDE63C979F63785256A700058EF2E|View this thread on the  forum...]]