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?