The relationships of linked table in Access

[Howard Chou]

I use Access at the front end to mysql. I created linked tables in Access to mysql tables.


Here are my problems.

1. I cannot find any relationships in the Access relationship window. I went back to MySQL and verified primay keys and foreign keys of all the tables in MySQL, found no problems.

2. When I open up Table One that has one-to-many relationship to another Table Two in Access, the + in front of each row is missing. Does it mean that I need to manually type in the index number of Table One in Table Two? It would be nice if this neat feature of Microsoft Access can be restored.


Thanks,