Ajoy Khaund wrote: > Hi, > > I am upgrading an Order entry form where the fields from the order table are on top and a grid below has the line items from the line table (no view or cursor used). Now I want to add a sequence field in the line table whereby I will add buttons to Insert a Line above an existing line and vice versa (insert below and existing line). > > OrderID is the Primary and foreign key for the order and line table. Now I want the grid to display the records on the sequence index. > > Using a view or cursor I can query after each insert but how do I do it using the tables directly.
I saw Dave's posts...good tips. I would suggest using a cursor/view instead, using an additional field for "display rank" and then having that default to the Primary Key generated (so that they're naturally showing in order added--assuming you're using integer keys or something else where you can tell what's later by the order of the key). Then make your changes, changing that that display rank field value (not the PK!). Show your data in DisplayRank order. hth, --Michael _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
