we use an order managing software called Stone Edge, which is based on MS Access. We now need an iphone app can display product basic info based the given product SKU. the database is hosted by SQLEXPRESS on a local server.
an iphone app which will
1) connect to our SQL database
2) fetch product info based on given SKU
3) SKU can be typed in or barcode scanned
and this could be an ongoing project as we'd like to add more feature to it in the future.