Code for Relationship ?

  • Thread starter Thread starter TA
  • Start date Start date
T

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
 
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
 
Back
Top