I have been asked to beegin construction of a replacement database.
The existing system has a number of linked tables where the number of records exceeds the 1 million mark.
Client (20k) -> notes (1m)
Client (20k) -> Widgets (73k)
Widgets (73k) -> Transactions (500k)
With this in mind do you think Filemaker will be sufficient to sustain this and grow with it over the next few years? They often add records in bulk as they take things on.