If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
General advice on way forward
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! |
#3
|
|||
|
|||
General advice on way forward
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! |
#4
|
|||
|
|||
General advice on way forward
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! |
Thread Tools | |
Display Modes | |
|
|