Title
Need advice from experienced FileMaker Pro "designer/architect"
Post
Hi
Already brought FileMaker Pro Advanced, since I think that will give me more control to simplify the interface for users less familiar with computers, and more control Portuguese localization issues - like errors.
My big issue right now -between the diagrams that sketch on paper - is if I should create a single database or several ones, and what will be the impact on future performance or limitations that I may have!
My application will have 3 major areas:
- 1 record of services performed or sold (the main principal app)
this will have some client info, scanned documents, product and service used with data got from area 2 etc.
- 2 Inventory of stock and available services.
- 3 Records of expenses from services rendered / sold and the company itself.
- 4 Vehicle millenage, services and usage records.
thanx
Vitor Costa
Portugal/Lisbon
Unless there is a good reason to go with separate files, I would go with all those as tables in one file. You won't have to duplicate security features, you won't have to make relationships twice between tables, you'll find it easier to pass script results and variables.