Ajoy, In the Line table create a composite key on the Order number and the seq number. I assume that both these fields are numeric. eg:
Index on str(order_number)+str(seq) to tag P_Order Assuming you are using the data environment, Drag the Order_Number from the order table onto the index P_Order you have just created. Now you must manually change the Relational expression in the Relation link so right click on the Relation link and select properties where you will see that the RelationExpr property is set to be Order_Number. Change this to be str(order_Number). So you are now linking the two files via the order number but the item file is in the order_number/Seq order which is what you want. Create your two grids and set record sources to be OrderTable and ItemTable Hope this helps, if not then ask away again. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajoy Khaund Sent: 02 December 2008 08:21 To: Profox Subject: 1-M Grid Index 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. TIA Ajoy Khaund Neamati Road Near Bhogdoi Bridge Jorhat 785001-21 Assam, India Tel: 91-376-2351288 Cell: 91-94350-92287 Mail: [EMAIL PROTECTED] Mail: [EMAIL PROTECTED] "Walking on water and developing software from a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ 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.
