Help print original value of FK

[josephbupe]

Hi,

Please, I need help to print Foreign Keys (CrimeID) back to original values (eg Theft) as stored in the table tblCrimes.
My tables are:

tblPersons (PersonID=PK)
tblCrimes (CrimeID=PK)
tblPersons_Crimes (Person_CrimeID=PK, CrimeID=FK)

Please, how can I do this?

Joseph

 

[SteveSchapel]

Joseph,

If I understand you correctly, I think you would simply make a query that includes both tables, joined on the CrimeID field. This will give you access to the CrimeName (or whatever it's called) field from the tblCrimes table, which you can then include in your report.

 

[josephbupe]

Hi,

Thanx Steve it worked.

Stay well.

Joseph