AnsweredAssumed Answered

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

Question asked by ShaikhAtta on Sep 8, 2014

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 

         

Outcomes