Access Help with relationships

[Brian Stuart]

Hi
I have two tables in Access
Clients with the client number as the primary key
jobs record with the job number as the primary key

I created a relationship between the jobs table(client number) and the client table (client number) it is a one to many relationship and shows the the jobs for each particular client. This works fine.

What I want next is a relationship that shows the client details for a particular job. I have tried just about every combination of relationship possible but no joy. As you can tell I am new to access and would appreciate any help
Thanks
Brian

 

[Brian Stuart]

Thanks Shoot1st,
Yes that makes sense but I will have to play about with the queries to get what I want. I do not have a foreign key assigned to the clientno in the jobs table but I will tootle off now and try it
Thanks for the help
Brian
p.s i told you I was a novice at this