I hope this the right place to ask these questions

I have been creating a program in 3.0b for some time now. (I've been creating classes, trying to learn this OOP) Any way here goes...

My data tables will reside on our LAN. Each 'client' will have the program installed on their computer and access this data via the 'server'.

1) Should I create local views of the data required for each of the forms?

2) Referential integrity...I have one parent table and 8 associated child tables with indexes set to the SSAN. Now I want to add the SSAN to each of these child tables (with 1 to 1 relationships. Must I have all these tables open when I add new personnel, create views with all these SSAN's, or will the information update to the child tables automatically?

3) Are there any white papers concerning RI and a better explanation on
its use?

4) How do I go about installing the database and tables on our server and have the installation routine of my program be smart enough to know the database is elsewhere with the ability to search our server and write the "databasepath" to either my program ini file or main header file?

And 5) Ultimately, what is the most LOGICAL way to accomplish this task??

I am coming over from 2.5 and I want to avoid updating all my other tables manually, but I may not have a choice.

Thanks in advance
Jon Paskett