The articles below will give you a good understanding of relational fields in TrackVia.
Please watch this video for advice on designing your application and establishing relationships between tables.