Junction Table

[chris11590]

I created a junction table as follows:

Tble

Junction ID- PK- autonumber
Incidents ID-fk (pk in another table)- number
Message ID- fk (pk in another table)-number

is this correct?

when i open the junction table, the two fields only display numbers (zero). How can I have the fields display the text data instead? I have converted it to text datatype but it reverts back to number datatype.

Do I use lookup wizard, run query?

 

[neileg]

You need a query to join the three tables together and return the related text fields. Your junction table is working correctly.