microsoft database training - automatic formtable creation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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.


 

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Server loaded in 0.1 secs.