Hi All,
I have a database I set up using MySQL. In my main table I have the Primary Key field set up as autoincrement and this field is then used as a foreign key in another table there is a one to many relationship. I am working with ACCESS as a front end, I am having problems with the subform, the feids go in fine on the main form but once I get to the subform all the fields turn to #deleted# I think it has something to do with the auto number field. Does anyone know of this and more importantly know the solution?
Thanks
R
I have a database I set up using MySQL. In my main table I have the Primary Key field set up as autoincrement and this field is then used as a foreign key in another table there is a one to many relationship. I am working with ACCESS as a front end, I am having problems with the subform, the feids go in fine on the main form but once I get to the subform all the fields turn to #deleted# I think it has something to do with the auto number field. Does anyone know of this and more importantly know the solution?
Thanks
R