My database records details of a site on which affordable housing is built.
It has a table for the site, the affordable bit of that site, the houses and
the funding for these houses. I am working with about 4 or 5 main tables in
all.

I cannot get clear at all how I should best lay this out for data entry. I
need to see the affordable site stuff, the houses on the affordable site and
the funding all on one page. Somehow this must relate to the main site,
though that (the main site) could be viewed on a different page.

I seem to get into knots trying to find a logical design. I've tried a form
for the main affordable bit, but the houses and the funding end up as two
sub-forms and it never seems to look good. I'm not sure how to relate this to
the overall site.

Any general tips on the best way forward would be much appreciated.

Hope this makes sense. I've had a long day with Access and my head is a blur!