Can you use an index to create a join between tables? 1

[IanGlinka]

I have a few tables whose primary keys consist of 2 or more fields joined together in an index. I need to join these tables either in the relationships window or in a query, but it seems access only lets you join single fields. Isn't there a way to join by indexes? I thought when you made an index like that, it creates a kind of logical field that is obviously used to check for uniqueness. Can that logical field also be used to create joins between tables?

Thanks
Ian

 

[IanGlinka]

Here's a snapshot of what I'm talking about:

 

[KenReay]

Hi yes you can join on 'compound' fields you just drag two (or more) join lines between the tables, joining the relevant columns Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[IanGlinka]

Oh, so I would join ADMITTING_NUM to ADMITTING_NUM, RECORD_TYPE to RECORD_TYPE, etc...?

I'll give that a shot, but I'm not sure if .. I guess I'm just a bit skeptical. Seems like that would only ... hmm... this is going to rack my brain, I'm just going to try it. It just seems to me, how would Access know which fields I were trying to group together? Here goes nothing:

 

[KenReay]

Hi

Thats it exactly

To convince yourself look at the SQL view! Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK