I've read other posts on this but from have seen slightly confusing information so I'd like some clarification.
I've been using Handbase as a CRM and cannot get acceptable performance with my current table design. The following is on my iPhone X.
There is an Organization table (parent) and a Contacts Table (Children). The Contacts table has one db lookup field pointing to the parent ‘primary key’ field and several Relationship fields which pull data from the parent based on this key value. This data is necessary for tracking in other tables. This has severe performance issues when opening the child table even with just 600-700 records. The parent table has 2700 records
* No relationship fields and the child table opens immediately.
* 1 Relationship field and the child table takes 4-5 seconds to load.
* 4 Relationship fields and the child table takes 10-11 seconds to load!
None of these fields used in views. While I could use a DB Popup field, this is very less desired as I'm often creating Contacts from the parent table and I'd like these auto-populated. If you make the other fields dblookups, only the first field auto-populates even though they are all in the same group. The only way to populate them is doing a manual dblookup again (as opposed to simply having them feed in when creating the child record from the parent table).
Additionally, if anything changes in the parent table, I'd like that of course to automatically update when viewing the child table. So am I stuck? Is there nothing that can be done? If there was a way that using a Link/Linked field combo I can live with that but as I understand it there's only one linked field. I've tried to follow advise in other posts (i.e. ensuring these fields are not used in Views, trying but not finding a db setting to disable auto-calculate for Relationship Fields)
Please, advise. Thank you!