mac os X dylemma

J

jsn

Registered
hi all

I have a client with 5 pc and 1 imac, connected in a local network. All of them have ms office.

my client needs a small application to manage cllients, keep trace of the services given to each client, and list all the products, services and prices. I can create it with ms access but the application won't be available from the mac. I can not recommend filemaker becaseu thre is already a free ms access database.

i was thinking about building a mysql database, with cocoamysql, and use a tool to create some forms and reports.

What tool do you know that can create forms and reports very easy, like in ms access ?

What tools do yo advice to build a cross platform solution, where the database can reside in mac or windows and the application can run from windows or mac?

Are there any open source tools for it ?

What other tool do you advice ?

thanks
jsn
 
There's also PostgreSQL that has some additional features. Or you could think about and embedded DB(s) such as HyperSonic SQL (http://hsqldb.sourceforge.net/), Xindice, Berkeley DB. As such they could be run from within a servlet container and so are platform independent.


Crystal reports can be called from JSP. So potentially cross platform there with that one.

There's this set of PHP classes that are for reporting that may help. PHP would fit both platforms as well

http://phpclasses.lightwood.net/browse.html/package/1017.html

Here's a link to an Open Source (I think) Java based reporting suite. This looks good.

http://ireport.sourceforge.net/screenshots.html

Hope these thoughts help
 
I am thinking about a tool or a wizard that will allow me to connect to a MySQL database select several fiedls froma table and create a data entry form with those fields.

I saw this kind of tood in Visaul Basic 6, it selects a table and creates a form, it is called "VB 6 Data form Wizard".

Thanks
jsn
 
Ah, OK. you have to remember that if your creating a web app then you're limited by what you can do with a browser. This is possible to do this. Take a look at phpMyAdmin. I don't know of any products that do this as such.
 
what about a standard java application ?

you already gave me the reporting tool

are they data entry form tools, that generate code in java ?

thanks
jsn
 
You must log in or register to reply here.
Back
Top