0 Replies Latest reply on Sep 8, 2014 11:33 AM by ShaikhAtta

    Creating a Sub Serial (e.g Numbering in MS Word)

    ShaikhAtta

      Title

      Creating a Sub Serial (e.g Numbering in MS Word)

      Post

      Hello, 

                 I have 2 tables (Table 1 = Types of eatables) and (Table 2 = eatable names) now the relationship between these tables is the Type ID field

                 Table 1 
                 TypeID
                 TypeName

                 Table 2
                 TypeID
                 EatableID
                 EatableName 

      I want my records in table 2 to have serials being issued according to the types like

      1.1, 1.2, 1.3, 1.4, and so on

      2.1, 2.2, 2.3  and so on

      3.1, 3.2 and so on