How do I design one database to query another database with static information?
I am designing a sales database that will be used by field reps on iPads without internet in some instances. There are a lot of image files related to the products that rarely change. I would like to keep the image files in a separate database to minimize the size of the sales database for downloading / updates.
1. Is it possible to access the photos database from the sales database?
2. How can I accomplish 1? (ideas, direction, different ideas)
I would also like to have a database on each device that keeps individual sales reps information that is not needed or stored by the manufacturer. Same idea as above, but the reps data would change more often.
Thanks in advance for any help.
(I am new to filemaker Pro, so go easy on me if I am missing something simple. :))