OK, I can see what the problem is and why you can't understand what I am trying to say - that it's not an ID field.........On my relations screen there shouldn't be connection between tbl_movieGenreCompact and tbl_movieGenre... - that's why I am saying that it's just a string. Sorry again. So it's just a string and then I will work out what numbers (1,2,30) in tbl_movieGenreCompact means with another SQL query to tbl_movieGenre, but that will be in a separate query. Thanks