Relationship question in multi file solution
I have a muli file solution that has one main data file and many applications (user interface) files.
If possible, I don't want to add any relationships to the data file, however the invoicing solution that I am createing requires a field that needs reltionship. What it is in Order table, I have a "total" field which gets a sum of all subtotal from OrderItems table.
But in order to do that I need a relationship.
Would it be possible to create some kind of solution in applicaiton file so that I don't have to add any relationship in the data file?