General advice on way forward

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!

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" wrote in message
...
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!

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" wrote:

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" wrote in message
...
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!

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


"C Tate" wrote in message
...
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" wrote:

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" wrote in message
...
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!