Accessing FilmStar Database

Technical Issues - Accessing the FilmStar Database

The FilmStar (Scantraq) Database includes FileMaker Pro examples and corresponding FilmStar BASIC macros to automate database operations by triggering FileMaker scripts.

FileMaker Pro supports up to 5 users without FileMaker Server. This utilizes FileMaker Sharing and requires that database(s) be open on a host computer (acting as server). For users with a file server, FileMaker Server adds further capabilities, supports more users, and is the robust FileMaker sharing solution. It is highly recommended.

While BASIC programming and FileMaker scripting skills are required to implement database solutions, end-users such as coating designers and QA technicians do not require those skills in everyday operation.

Users can assign BASIC programs to Macro Buttons 1-6, but that is only recommended during program development. Database macros should be assigned to menu commands in File and Spectra menus via the Database Configuration dialog.

Spectra Database

The above screenshot shows how DB commands are added to FilmStar. Click File.. Configuration.. Directories followed by the Database Configuration button. If the button is missing, contact FTG Software about upgrading to a Facility License.

The screenshot at the right shows a DB Retrieve menu added in the Spectra menu. Typically there is no requirement for Save Spectrum in DESIGN unless one is producing a sales document.

FilmStar Database examples are intended as a starting point and need to be modified to meet particular requirements. With over 20 million users, FileMaker Pro consultants are readily available. When selecting a consultant, your want to hire someone familiar with ActiveX (as in Excel VBA).

You probably don't need a consultant. In fact, several FilmStar users assigned summer interns (physics or math majors) to the task, reporting that they 'figured it out' (with minimal support from FTG Software).

Back to Technical Issues