2004
Table Of Contents
- Contents
- Chapter 1 - Find the Information You Need
- Part 1 - The User Interface
- Part 2 - Start, Organize, and Save a Drawing
- Part 3 - Control the Drawing Views
- Part 4 - Create and Modify Objects
- Chapter 14 - Control the Properties of Objects
- Chapter 15 - Use Precision Tools
- Chapter 16 - Draw Geometric Objects
- Chapter 17 - Change Existing Objects
- Part 5 - Hatches, Notes, and Dimensions
- Chapter 18 - Hatches, Fills, and Wipeouts
- Chapter 19 - Notes and Labels
- Chapter 20 - Dimensions and Tolerances
- Part 6 - Create Layouts and Plot Drawings
- Chapter 21 - Create Layouts
- Chapter 22 - Plot Drawings
- Part 7 - Share Data Between Drawings and Applications
- Chapter 23 - Reference Other Drawing Files (Xrefs)
- Chapter 24 - Link and Embed Data (OLE)
- Chapter 25 - Work with Data in Other Formats
- Chapter 26 - Access External Databases
- Overview of Using AutoCAD with External Databases
- Access a Database from Within AutoCAD
- Link Database Records to Graphical Objects
- Use Labels to Display Database Information in the Drawing
- Use Queries to Filter Database Information
- Share Link and Label Templates and Queries with Other Users
- Work with Links in Files from Earlier Releases
- Part 8 - Work with Other People and Organizations
- Chapter 27 - Protect and Sign Drawings
- Chapter 28 - Use the Internet to Share Drawings
- Chapter 29 - Insert and View Markups
- Chapter 30 - Publish Drawing Sets
- Part 9 - Create Realistic Images and Graphics
- Glossary
- Index
Link Database Records to Graphical Objects | 739
association between the graphical object and the database table by creating
a link, which references one or more records stored in the table. You cannot
create links to nongraphical objects such as layers and linetypes.
Links are tightly connected with the graphical objects they are associated
with. If you move or copy a linked object, the link is moved or copied with
it. If you delete a linked object, the link is also deleted.
When you create a link, a dynamic relationship is established between the
database record and the object. If, for example, you convert a room from a
storage area to an office in the database table, AutoCAD provides a mecha-
nism to update the information stored in the drawing so that it matches the
table.
To establish links between table records and graphical objects, you must first
create a link template. Link templates identify what fields from a table are
associated with the links that share that template. For example, you can
create a link template that uses the field Room Number from a room database
table. You can then use this link template to create links that point to
different records in the database table.
Link templates also function as shortcuts that point to the database tables
that they’re based on. You can use the link templates that are associated with
a drawing to open the tables that they reference for viewing or editing. This
is particularly useful if you have a large number of data sources configured
on your system. Rather than scrolling through a list of data sources each time
you want to locate an individual table, you can open it directly from the
drawing node of the drawing that it is associated with. To open a link
template’s table, right-click a link template in the dbConnect Manager and
choose View Table or Edit Table.
You can attach multiple links using different link templates to a single graph-
ical object. This is useful when you want to associate data from multiple
database tables with an individual object.
Links in External References and Blocks
Links stored in externally referenced drawings cannot be viewed or modified
in the master drawing that they’re attached to. This information is only
available when you open the source drawing directly.
Links contained in blocks are available, but can only be accessed through the
REFEDIT command.