Perhaps by hiring a consultant? :smileywink:
Sorry about that, but you really sound like a client that is telling their consultant what they want their database solution to do for them. You've posted a lot of general facts without a lot of detail.
How familiar with database design (in general) an Filemaker Pro (specifically) are you?
I think I'll hire a consultant lol. I'll need one.