I have a client that has a simple Relational DB application. They are currently working with a single table webex DB solution , but would like to take it to the next level - ie cross link a master table with two supporting tables. MS Access would be ideal for this, however the company is small (4 users), they run on Macs, and they have no IT department so no central servers, and work out of home offices across the states. Expected number of records is 1000 per year.
My expertise is not in web database app development, and in researching this a bit, I have discovered there are a myriad of web development platforms out there, with nothing to help guide a newbie - lots of camps focused on their chosen tool, but nothing to help choose the best tool for this application. Also, the tools do not seem to be as powerful as would be desired, so development costs would likely be high. What would be ideal is something that had the power of Access, its ability to build forms with embedded subforms. And a report generator like Access' which can put together a report that had master records, followed by sub records on the same page.
Thanks - Charlie