Master/Detail Relationships

From RemObjects Software

This is a Data Abstract Architecture entry
Feel free to add your notes to this topic below.

Data Abstract actively supports tables in Master/Detail relationships, and provides options that make it easy to establish Master/Detail relationships between tables.

Relationship Modeling in Schemas

Data Abstract schemas support relationships as part of the meta data stored in the schema for data tables.

Depending on the database driver used, relationships will automatically be established when importing tables or views form the back-end database into the schema. Schema Modeler also provides the Relationships View that allows you to manually define and edit relationships between tables.

Finally, Schema Modeler's Diagramming and Modeling Support visually shows relationships as part of the schema diagrams, and allows establishing of new relationships using intuitive drag and drop operations within the diagram.

Relationships and AutoIncs

Data Abstract also uses master/detail relationships defined in the schema to allow automatic handling of AutoInc values, making it possible to use integer based AutoInc primary keys in disconnected clients.

Automatic Fetching and Updating of Master/Detail tables

Finally, Data Abstract provides support for automatically linking master and detail tables on the client side, including the options to incrementally fetch data for detail tables as the user changes records on the master, and automatically applying changes to masters and details in one step.

See Also

• Schema Modeler
• AutoIncs
• Lists
  • Namespaces
  • Classes: .NET — Delphi
  • Interfaces: .NET — Delphi
  • Enums: .NET — Delphi
  • Types: Data — File

Product: RemObjects Data Abstract
Current version: Data Abstract 'Vinci' (5.0)

Lists — Glossary — Features — How To — Drivers — Components — Tools — Samples — Articles — Architecture — Issues