I am building a database to collect information about client visits to a therapy centre. I have a main client table linked to tables with associated contact details, I think I need to set up one to one associations with the main table (specific tables are horse(main), owner, rider, farrier, vet). I also need to set up one to many associations with the therapy tables (Spa, Treadmill, massage). can anyone explain this to me. it is about 20 years since I last used access so have forgotten almost everything I once knew.