identifying types of dependents

[deekras]

i inherited 2 tables - one for members, the other for the member's dependents. the dependent table has a field for the relationship - spouse, child, parent, grandparent. they are linked by member id.

i need to identify the type of dependent with a 2 digit code. but the tricky part is: the first child gets a code of "03", the second child is "04", etc. up to "19". the first parent is "20", the second "21", etc up to 29. and the same for grandparents "30" through "39".

each dependent must be its own record with the linking member id and other fields that are easy to include.

i need to export the info to excel, so i really cannot use a report or form.

any suggestions?

 

[deekras]

i guess i wasn't clear. the dependent table has a field that says "spouse", "child", etc.

i need to make the code based on the type of relationship. spouse will be "02", the first child will be "03". if there is another child, he is "04", etc.