View Full Version : Junction Table


chris11590
08-26-2008, 04:34 AM
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
08-26-2008, 06:04 AM
You need a query to join the three tables together and return the related text fields. Your junction table is working correctly.