98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » microsoft database training - Automatic Form/Table creation
microsoft database training - Automatic Form/Table creation
Resolved · Low Priority · Version Standard
Automatic Form/Table creation
Why does Access add a table to my form when I use the AutoForm option?
RE: Automatic Form/Table creation
Answer to the question:
Access will analyse the table before an AutoForm is created, if there are relationships in place; where your table is the 'one' side of a 'one to many' relationship, then Access will include the secondary table as a sub-form, this will enable you to view the main table records 'one side' and also scroll through any of the 'many side' records on the sub-form.
If you wish to create a Form from your secondary table and use that rather than the default secondary table, you must insert the sub-form manually in the main Form's design view.
Sub-Forms are covered in detail on the Access Advanced course.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |