Code for Relationship ?

[TA]

Hi guys,
Is it impossible to set relationship between 2 record set
in Access?
Like I have old code from visual foxpro:

Select 1
Use Error_refer
index on CODE tag code

Select 2
use Mainerror
set relation to CODE into Error_ref Additive
Report form ErrorMain to printer

Best regards,
TA

 

[GreySky]

It's called an INNER JOIN.

Select ER.*, ME.*
FROM Error_refer AS ER INNER JOIN Mainerror AS ME
ON ER.Code = ME.Code

David Atkins, MCP

 

[TA]

Thanks David.

Best Regards,
TA