Nestor Posted July 23, 2014 Share Posted July 23, 2014 I have a db with over 20k records and I'm introducing a new field to my child table. Each Parent cant have many childs and for each child I would like to assign a unique number starting with 1. the goal is to see all my child items the following way. Parent, child ID, ActivePortalRowNumber 6294 14785236 1 6294 14785237 2 6295 14785238 1 6296 14785239 1 6296 14785240 2 6296 14785241 3 My current challenge is that I can create a calc to get the active portal row number, but its only going forward. how can I go back and set the rest of the 20k. Thanks. Link to comment Share on other sites More sharing options...
eos Posted July 23, 2014 Share Posted July 23, 2014 That's not really a portal row number … Anyway, to get this numbering, in the child table create a summary field sCountOf<anyGuaranteedNonEmptyField>; set it to Running Count, with restart when sorted by parentID (from the TO the portal is based on); sort either the relationship or the portal by parentID. (Note that you could use this field to create a summary effect in the portal, e.g. by giving each parentID where summary field ≠ 1 the text colour of the background colour, or a font size of 500 …) OTOH, if you have a portal that shows children for only one parent, you can simply put a record number symbol into the portal row. 1 Link to comment Share on other sites More sharing options...
Nestor Posted July 23, 2014 Author Share Posted July 23, 2014 Thank You. That did it., Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3536 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now