Entering Data in a Table on the Many Side of a M:1 Relationship

1
Entering Data in a Table on the Many Side of a
M1 Relationship

• If you came to this presentation via a web
  browser,
• right-click and choose Full Screen before
  proceeding.
• Click mouse or press space bar to continue.

• This presentation was prepared by Professors
  Steve Ross and Kraig Pencil, with the advice of
  other MIS Faculty, for use in MIS Classes at
  Western Washington University. Please contact Dr.
  Ross for permission to use in other settings.

2
The Challenge

• Create a form for the entry of worker
  information, to include the foreign keys for
  DepartmentID, RankID, and SupervisorID

3
Step 1 Source Data

• Create a view containing the data for the form
• Normally, the view is based on a single table
• vueFrmWorker contains all fields of tblWorker
• Determine field and control characteristics

4
Step 2 Layout

• Create a draft view of the form, giving
  approximate placement and type of controls for
  each data item

This field cannot be edited, and so the text box
control will only display the values.
I usually do this by hand, not in a graphic
program such as this
These will be text boxes bound to the relevant
fields
Foreign Key fields are often entered via combo
boxes
5
Step 3 Create Version 1

• Use the view created in Step 1 as the record
  source for the form
• Depending on your production environment
• Use application generator to create form
• Create form from a design master
• Add all desired fields to the form

6
Step 4 Fine Tuning

• Convert text boxes to combo boxes or other
  controls as necessary.
• Apply check constraints and other properties to
  controls.
• Once controls are set, apply other design
  standards.

See this presentation for discussion of
technique. The form illustrated met MIS 421
design standards when it was created. Subsequent
changes to the standards may have occurred.
7
Step 5 Quality Assurance

• Can the user change data in an existing record?
• Can the user enter new records?
• Are all constraints working properly? (Test the
  limits.)
• Have all Design Standards been met?