Hi all

I have been reading about the pros and cons of the separation model and I am thinking about using the separation model in a runtime solution that I have written. I known the reason to do the separation it for easy of upgrading the front end (data entry) without messing with the back end (data storage). But I have a question that been bugging me about the relationship part.

You have to have at least a couple of relationships from the front end (data enrty) of the program to the back end (data storage). If that is true, then how do you recreate these relationships to the old back end (data storage) to the new front end (data enrty) when the old front end (data entry) is update?

The file reference will not change. The relationship of the Table occurences are based off that file reference. So when you make an update to the front end, it could still reference the same data file. This is of course pending any changes you make to the relationships and or field/table structure of your data file.

John

Thanks for the information.

Lionel