Quote:Can you describe the structure of your application
The structure is convoluted and apparently screwed up.
I thought I was building it fairly basic but..
It has a parent database that has a few child databases on subforms and a number of grandchild databases in subforms. all databases are linked together with natural links and has logic to create a shared key amongst the databases also.
The short explanation is:
The database consists of a parent Named firm. The firm has a child named firm address that allows multiple address locations for the firm to be associated with the firm. The Firm also has a child named Contact that holds multiple contacts associated with the firm.
The contact database has a child database called property. The contact can have multiple properties associated with each contact.
The property database has a child database called paymentst. Each property has many payments associated to the property.
The property database has many tabs that stores data such as employer info, financial info etc. There are a number of process that happen when the record is entered one for example is it goes out and looks to see if a specific form has been received, if it has it places a checkmark in a element and turns it green. There are numerous other assorted features.
Seeing it might explain it better then my words. If you like I can send it your way.
Thanks