The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Solved
Form development
Posted on 2013-01-01
Experts,
Its not advisable to make a form with a subform built off of the same tables?
I ask because displaying all information in the form might make the form hard to read. i have seen professionally built databases where you click on a part of the form and other areas (subforms) update. Is each subform typically built off of a separate table? I believe so however a separate query to find data in those forms and subforms could require all of the other subform tables. I mean you would have to drag in all of those separate tables, correct? I guess it shouldnt be a big deal if all the tables were linked properly.
if the form was instead just built off of 1 table then queries would require only 1 table,, correct? I am trying to figure out the benefit of having multiple tables i/o havin 1 table (in this case).
thanks...
Its not advisable to make a form with a subform built off of the same tables?
I ask because displaying all information in the form might make the form hard to read. i have seen professionally built databases where you click on a part of the form and other areas (subforms) update. Is each subform typically built off of a separate table? I believe so however a separate query to find data in those forms and subforms could require all of the other subform tables. I mean you would have to drag in all of those separate tables, correct? I guess it shouldnt be a big deal if all the tables were linked properly.
if the form was instead just built off of 1 table then queries would require only 1 table,, correct? I am trying to figure out the benefit of having multiple tables i/o havin 1 table (in this case).
thanks...
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active 1 day ago
<<Is each subform typically built off of a separate table? >>
Yes. The whole idea of a main/subform combination is that you have a parent record related to one or more child records in another table.
There is no reason to use a main/subform combination for a single table unless your trying to do something with a table that relates to itself.
If you need a better layout of a form for a single table, you want to use a tab control.
Jim.
Yes. The whole idea of a main/subform combination is that you have a parent record related to one or more child records in another table.
There is no reason to use a main/subform combination for a single table unless your trying to do something with a table that relates to itself.
If you need a better layout of a form for a single table, you want to use a tab control.
Jim.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Suggested Courses
Course of the Month7 days, 17 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.