Hi John,
Ran into problems near the end of the Script.
1. Created a new Unique Value Field by combining 2 alpha and one numeric fields in the master file. Called it UniqueID
2. Created 2 new text fields a] called "DEL" [included inverted comma's.] b] called GLOBAL as a global field...
Our FM 5.5 Pro DB has more than 30,000 files of which 20,000 are duplicated [ie file is duplicated 3 times]. Is there a simple way to mass delete 2 of the 3 files leaving us with a clean, duplicate free DB?
A Master DB [links with 7 other DBs] being is systematically and progressively updated by several users from different locations. Is there a simple way for the next user to locate the last updated record?
The database size may be an issue, but the seek and find time will definately test your patience in FileMaker. Good as Filemaker is, look into MySQL for a database solution that will expand with your growth and lower your frustration levels.
Cheers.
We are building a giant dbase for a new web site. As there are many staff who will input data and we have FileMaker throughout the company, we plan to build the file in FileMaker but ultimately port to MySQL for online use.
We sell fonts, over 65,000 of them, many in up to 4 formats. We are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.