I spent many years developing a robust database on MSAccess and now I have changed companies and need to start another. A lot has changed in the 11 years since I started working with databases, but I don't know anything other than Access. The database I need to build will be used entirely or primarily within our office with less than 6 users. It would be great if I could create a limited interface usable on my iphone, but this is not at all necessary.
Filemaker issues: The reports will get fairly complicated by pulling from more than 15 tables and I have heard that filemaker may have some limitations with that. I like to use comboboxes and listboxes a lot and I have heard filemaker has limited options with these.
mysql: Is there a front-end development program that is similar to Access or possibly easier to use? It seems like knowledge of php is necessary and I have heard it is fairly complicated. I do not have any other programming knowledge as I was self taught on MSAccess and learned necessary coding primarily from this site and other online resources.