Creating a proper key

Hi I made a simple table with 3 fields to be used with a subform. (Code, date, text). In order to make multiple lines with same code and date, I have set the key “code,date,text”. It works fine, i just feel that it is not very nice. Is it possible to create a field e.g “line No.” which automatic counts up with the previous line number + 1, whitout using C/al code. (Not afraid of coding, but we have no licence to code on tables and forms) regards Karl

Hi … You should have the key as Code, Line No. and then on the form that is displaying this data you set the AutoSplitKey Property to yes. Then inserting on that form will automatically update the Line No. field. Br, Gulli

Just look at the SalesLine sub form for an example.