• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Exploring Forms and Controls > Dealing with the Underlying Records

Dealing with the Underlying Records

To properly explore how the underlying records relate to a form, the best place to start is the Record Source property. Both tables and queries tied to forms through the Record Source property use updateable record sets. The fields available to the form depend on the table or query that is tied to the form. This list can be expanded in a number of ways. One way is to add another table to the select query that is attached to the form. Another method is to create a lookup control that relies on another table for its fields. These fields then become available through code using the column property.

Multiple Table Queries as Record Source

If your form is tied to a select query that is based on one table, there should be no problem editing records. But when the query is based on more than one table, it gets a little more interesting. If you want to edit a join field on the one side of a one-to-many relationship, you must enforce referential integrity and cascading updates in the relationships window. This is a plus because you want to guard the integrity of your relationships.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint