How to auto calculate child table 'lineNo' value ?

surajitkundu · October 30, 2012, 11:36am

Hi Expert ,

I have created a form with one table using Object Designer . Its working fine.Now i want to work with child table but i am facing a problem how to maintain child table ‘linNo’. Please give me suggestion how it can be possible to auto calculate ‘LineNo’ field value .

Thanks Surajit

amol_salvi · October 30, 2012, 11:53am

Look at the standard form & subform concept…

surajitkundu · October 30, 2012, 2:30pm

Hi amol ,

I think , we need to be add code in Code unit .Am i wright ?

Thanks

Surajit

jvalidashti · October 30, 2012, 5:09pm

Not necessarily! It all can be done by your tables’ triggers.

Why don’t you take Amol’s advice and would look at some existing Header and Line tables?!

babrown · October 30, 2012, 8:32pm

Looking at the tables isn’t going to help. As Amol said, look at the forms.

Search “AutoSplitKey” in Help.

amol_salvi · October 31, 2012, 1:35am

Using Autosplitkey property.