This question is locked. New answers and comments are not allowed.
If you are doing any type of disconnected app and are using SQL CE as your local DB store then here is a very nice addin I have been using.
http://exportsqlce.codeplex.com/
The problem this solves is that when you synchronize your local database cache with your master DB it does not pull over relationships between tables and thus OpenAccess doesn't know to generate the child fields for those related tables. What you can do however is reestablish your relationships on the CE DB, pain I know, and then use this addin to script out those relationships. That way whenever you need to add or remove tables to your local DB cache and the relationships you setup are blown away you can simply run the exported script against your CE db and boom relationships are back.
Huge time saver. Anyhow I was delighted to have found this and thought I'd share.
http://exportsqlce.codeplex.com/
The problem this solves is that when you synchronize your local database cache with your master DB it does not pull over relationships between tables and thus OpenAccess doesn't know to generate the child fields for those related tables. What you can do however is reestablish your relationships on the CE DB, pain I know, and then use this addin to script out those relationships. That way whenever you need to add or remove tables to your local DB cache and the relationships you setup are blown away you can simply run the exported script against your CE db and boom relationships are back.
Huge time saver. Anyhow I was delighted to have found this and thought I'd share.