Search results

Thanks Minty, Not sure that I was too clear there. Each Speciality has a specific Function, so the Function Table has a one-to-many relationship to the Speciality Table. Then each Contact could have multiple Functions, with multiple specialties attached to each function. Anyway I'll try...

Thanks for the reply Minty, When you say list them all, do you mean list out each Speciality individually as a field on the new table? Then have a True/False value for each? There are about 12 Functions, each with around 10 Specialites, so roughly about 120 fields, is that okay? At the moment...

Thanks for the help. I've read over the article (and a couple of others about Many-to-Many relationships), and I can see how they work in examples like Albums (or Books), where both Artist and albums reference each other: Artist can have multiple Albums, Albums can have multiple Artists, but...

Hi Guys, I'm a pretty novice user of Access. Thought I knew what I was doing until I tried to created a complicated contact database. I'm trying to set up a DB with hundreds of contacts, which I want to be able to sort via two main fields. Functions and Specialisation. 'Functions' is more or...

Hi Guys, I'm Jonathan. Been working with MS Office for years but am new to Access. Despite having a Microsoft Office Specialist qualification in Access, I still find it a little bit :banghead: