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?
Thanks in Advance.
J. Turner