A complete guide to subforms

Tutorials Shared by the Internet Community

Advertisements


Synopsis

There are various ways you can solve such a problem.

Statistics

  • Total Hits - 16374

  • Total Votes - 109 votes

  • Vote Up - 50 votes

  • Vote Down - 59 votes

  • Domain - www.functionx.com

  • Category - MS Access/Forms

  • Submitted By - Shekhar

  • Submitted on - 2008-04-15 07:21:56

Description

Relational database allows you to separate data in objects so that these objects can hold different pieces of information and make data available to other objects that need it. Sooner or later, users constantly need information held by one form while they are working on another form. There are various ways you can solve such a problem. One solution is to "embed" one form or report into another form or report.

A subform is a form that you position inside of another form. In order to "include" one form into another form, both objects must have a relationship, as we have learned in the past. The form that is hosting the other form is the parent. The form that is added to the parent is called the child form. The parent form must have a primary key that "links" or relates it to a foreign key in the child form. This foreign key of the child object must be of the same data type as the primary key on the parent object. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements