Morning

I am a bit stuck as to what direction I should be heading in for a system.

I have an App which runs of a main Parent Table, and there are many Child Tables related to it. The system will contain around 10 forms, 1st one holding the Parent Table, and the remaining 9 holding Child Tables. These tables can be at certain points, be opened all at the same time.

In terms of speed/efficiency - should I go for the Local Views approach, or should I use just the tables and set loads of Relationships up - I am in a twist on this one.

The key issue is speed of the system - including loading times etc.

Can anyone give me some advice on this.
Greatly appreciated.
Thanks
Kev