To split the add form into 2 sections.
In other words, have user fill out first section, click to load the 2nd add form and
1. either add the first form and come back and add the second form to the same database or
2. Enter info on first form and then load second form and add both all at once.
3. Create another database to hold the second part and then do a link to both as necessary.
Hope this is clear on what I want to achieve. The data base is over 100 fields big, but not all fields will ever be completely filled.
Tom