I am about to start conversion of a MS Access database into Lotus Notes.
Has anyone had any prior experience in doing this, and what are the recommendations.
I know that Access is a relational database, Notes is hierarchical etc.
What I am after is how people have deisgned solutions to overcome the differences in the way these two different types of database work.
i.e. should I be using subforms, embedded views, lookups etc.
There are 16 tables in the access database. Most relationships are 1 to many. I know I can not relate documents in Notes, so how is this problem overcome? I am thinking I could use a lookup on one form to lookup the key values from a view?
However, in Access if this key value changes then all records are updated. Is there any way to recreate this in Notes?
Thanks for all your help as always!