I think you are going to have to get a bit more detailed than that. What happens when they are both soldiers? What about having a spouse and an ex-spouse? How about children that are soldiers?
I know you would like them to have only one spouse, but that's not the real world.
How about parent table and dependant table?
Parent defined as soldier or not
Parent defined as male/female
Parent status as married,single,divorced
Parent has pointer to spouse in same table
Dependant has pointer to parent 1 and parent 2 (or could just point to soldier)
If you don't point to both parents in parent table from dependant, you could have problem knowing who the dependant belongs to (you know soldier, but may be ex-spouse).
-w-
>Can anyone recommen the best way I can relate the following tables:
>
>Soldier table - soldiers data
>Spouse table - soldier's spouse
>Dependent table - soldier's children table
>
>Soldiers can have only 1 spouse and multiple dependents. Any ideas on how I can put them all in one view?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown