Hey all

As you prob know by now I do my own ratings etc, I save them as a "data warehouse" type setup in a MS Access database. I am self taught re computers so I use MS Query in Excel to run form queries and ratings queries (ie past race) to rate races and to bring up the form etc upcoming. It's messy but it works for me.

My query is this:

How do I make an inter-relational (is that the right term?) DB in Access, so that I can make say Horse Name the common field so that info I save in the secondary database can be automatically brought up when I query the first DB?