Ajoy, No relationship is required in the grid only in the data environment. The fact that you set the relationship in the Data Environment permanently links the tables together for that session. With regard to the keys not being the same length, that is the whole point. The Orders table links to the item table only by the order number, hence extracting only the items for the currently selected order. However, because the item table is using a composite index based on the order number and seq then it is displayed in seq sort order.
If you just have two grids , one with the "orders" and the other with the "items" as recordsource properties then this will work fine. You must remember however to put in the orders grid "AfterRowColChange" event a refresg for the item grid such as Thisform.grdItem.Refresh. If you don't then the relationship will not be displayed in real time. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajoy Khaund Sent: 02 December 2008 16:43 To: [email protected] Subject: Re: 1-M Grid Index Thankx I was following something like this from foxite. My parent table fields are in textbox and a vcr control is used to move. The grid is not showing anything. I suppose you have to set the same relations in the grid also. Length of str(orderid) might not be same as str(orderid)+str(seq). Can that be an issue ? 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" -------------------------------------------------- From: "Dave Crozier" <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2008 4:47 PM To: <[EMAIL PROTECTED]> Subject: RE: 1-M Grid Index > 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.
