General advice on way forward

[C Tate]

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!

 

[Mark A. Sam]

It is difficult to understand this. What does "the affordable bit" mean?
Why are examples of the data? What is the purpose of the database?

 

[C Tate]

Sorry! I realise this post is not very clear. Just ignore it and I will ask
more specific questions in future. I think I was trying to ask what the best
way to display a lot of information on one page, when you have perhaps up to
4 different subforms (and tabs aren't really suitable). I need to target
questions more carefully.

 

[Mark A. Sam]

It is difficult to say what the best way is. I think it is up to the
developer, but I like to use tab controls. I like to access "lookup" data
from popup forms. I have one form where I have three layers of subforms
(subforms within subforms). I don't have time to count how many subforms
are in that main form. But it works well.

God Bless,

Mark A. Sam