Any one got any sugestions on the best way to view a multi level database in form view. The only way I can think of is a series of subform but it is not very satisfactory as the dispaly is very cluttered and not easy to understand if you are just an inputer rather than someone who understands database structure?

Have you thought about using pages (well actually called tab controls)? That way you can split your data into groups giving the tabs relevant names. It also stops the need to have the user scroll up and down when all the data doesn't fit to the size of the screen.

You said about subforms - well you either NEED to use them or you don't, but by using tab control you can spread out your fields / subforms in an easy to read manner.

HTH - Ally


[This message has been edited by Ally (edited 05-20-2002).]