My suggestions are
1. Make a copy of your file
2. Rename UI-file
3. Create a External file connection from your UI-file to your data-file
4. For each relationship table occurrence in your UI-file, change to Data-file
That is your first start, then you need to do more and for that I recommend you do use a Analys Tool like
Base Elements - BaseElements | Goya Pty Ltd
to get hold of what data that is un referenced and delete all those.
what i would like to know is:
- can i make all the relationships in the master ui files without make relationships in the data files?
- can i build all the scripts in the master ui file?
Yes, and yes. This is referred to as the "separation model". You only need those relationships in the data files that support field calculations or options like lookups.
Thanks. So i can't use lookups in ui file relationship without the relationship in the data file?
Now it's clear. Thank you all.