Hi

I am hoping that somebody can tell me if Sesame can do this?

I want to make line numbers for each of the PO subform line like the ones that show on the subformscreen on left side.  But I need to keep them the same as the subform shows, the sequence order . And i need to have the PO top form to show the number of lines on the subform.  And if I remove a line from the subform then the remaining lines need to be reassigned to the new numbers and the total number pf lines on the PO has to go down by a count of 1.

Some times the lines need to be sorted by date, and sometimes by part number  When this new sort happens the line number has to change also so final line number is always the same as the number showing on the sub form.

Is there a way to set this up?  Thank you in advance.

Thank you for the programming.

I will try this out and get back with results.

Ignore the code I submitted above.  Just got a chance to test it out, but it has problems.  Cannot debug it now, but will edit the original to warn it does not work......

Sorry about that, I told you it was untested. 

It might be less confusing if I delete it completely?

Hello obfusc88

Sorry for any confusion.  I did not expect to be available as of today,  but here is some tested working code before I am off the air.  This is the best I can do right now.

1.  On the "parent" form named PO, add a bound number LE, ReadOnly, named LineCount

2. On the "subform" named Lines,  add a bound number LE, ReadOnly, named Sequence 

3. On the subform Lines,  put the following programming in the Sequence element, to execute On Form Exit:

var vLineCount as Int

//Uses the current position of the record set
Sequence = @ResultSetCurrentPosition()

//Gets the total number of lines in the record set
vLineCount = @FormResultSetTotal("PO!Lines")

//Sets the Line Count on the parent form
FormFieldValue("PO","LineCount",0,vLineCount) 

===============================
In addition to working, it is much smaller and easier to follow. 

Note...this does not automatically update if a record is deleted.  Need to step through all records. 

I suspect that it mayl be necessary to make a macro that sorts and/or does a Mass Update to the records in the subform, and then runs this code in each record.  Once the macro is created, then you could call the  macro vs. calling this code.

If you cannot make the macro, check back here and someone will be glad to help.   (Mark can probably come up with an easier solution than a complex macro).

I am still needing to step through all lines to keep the numbers correct   Is there any way to make all the lines in the subform run when another one is changed?

And is ther a way to tell that a new subform record has been added to the parent? -new total lines will be more.

Is there a way to tell tha a subform record has been deleted from the parent?  new total lines is less.

Thank you and Happy Holidays.

Quote:

Maybe you would need a command button on the parent that executes code that will loop through all of the subrecords and reassign them a new number.

At one time I also had some code in a subform to calculate the total of the subrecords, and place that value in the parent record. But, I found it was better to put the code in the parent form's Global Code event as a Subroutine, which is called in the parent's On Form Exit, On Form Change, and in a command button. The button is so I can force a recalculation if I am not making changes to the parent record, but have changed a subrecord.

Quote:

That's okay, luckily, Sesame can tell us how many there are.

Quote:

No, it won't. Sesame does not consider moving from a subform to the parent an On Form Entry event. You would need to advance to the next parent record and back again, for the On Form Entry event to execute.

Quote:

Well, you have a few choices here.

1) There's nothing to stop you from putting the code in the command button AND another event, like the the parent's On Form Exit. That way, if you want to see the line numbers right away, you can click on the button. If you don't care to see them right then (or if you forget to click the button), the parent's On Form Exit event will take care of it.
2) You could also place the same exact code in a subform event. If you put it in the subform's On Form Exit, it will re-number the lines every time you navigate up or down the subform lines. The only problem with this one, is that it can be a little distracting, because the gray highlight will scan from the top subform line to the bottom one every time you navigate up or down.
3) If you don't need to see the new numbering until the next time the parent form is viewed, you could simply place the code in just the parent On Form Entry event.

Just keep in mind that placing the code in an exit or entry event for the parent, may slow you down while navigating the parent records - especially if there are a lot of subform lines. In any case, you'll probably want to test it in a few different events to see what works best for you.

var vCnt as int	//Subform count
var i as int	//Subform instance


//Tells us the number of subforms for this parent
vCnt = @FormResultSetTotal("MySubform")


//Loop through all of the subforms
//"MyLE" is the name of the subform LE that you want the line number in
For i = 1 to vCnt
	FormFieldValue("MySubform", "MyLE", i, i)
Next
 

Let me know how you make out.