Creating more records

[MTSPEER]

Hello Guys,

I need some help with this confusion I'm having. I have a table called Table1. And Fields ID and Age. If the age is < 60 I need to send this over another table called Table2 where there are two more fields, Number and Level. The ID's who's age is under 60 should look like this in the other table:

ID Age Number Level
1 56 11 5


1 56 12 6
1 56 13 6
1 56 14 7

And there are multiple ID's in Table1. And I want every ID who's age below 60 to produce this on Table2. I'm not sure what is the best way to do this. Thanks

[June7]

Why saving age and not birth date?

Why do you need other table? Can this 'level' be calculated? Why is 6 repeated for numbers 12 and 13?

[MTSPEER]

Because there is no birth date field. Just age. And I want to move it to a different table because there are so many more fields in that table and I just want to make things simpler. No the "level" field cannot be calculated. Because that is just how it has to be. And every ID will have the same setup. same levels and numbers.