How do I identify the system id for a specific field?

G

Guest

We are trying to link AutoDesk Architectural 2006 to an Access mdb table.
When we view the data in the database the information is in the correct sort
order but when the drawing opens it seems to randomise the data. Is there
any way in which we can identify the system ID of the field and link to that
so that the link is set more firmly? Any ideas and help would be
appreciated.
 
R

Rick Brandt

emmab said:
We are trying to link AutoDesk Architectural 2006 to an Access mdb
table. When we view the data in the database the information is in
the correct sort order but when the drawing opens it seems to
randomise the data. Is there any way in which we can identify the
system ID of the field and link to that so that the link is set more
firmly? Any ideas and help would be appreciated.
Click to expand...

Presumably the table has a field or fields that you could sort on to achieve the
order you want. You need to use the Sorting and Grouping dialog in the Report's
design view to set the sort order of the report on those fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to view the system ID for a specific field? 1
Table Def “Connection†info (Database Name) 4
Field Values When Linking to an Oracle Table 1
Unique Record Identifier for MS SQL Server Tables (BE) Linked to Access FE 2
Specific Values List Missing 1
Excel Import / Referential Integrity Question 8
how do I query the current Win logon id in a nonsecure Access db 4
Link to ODBC - stumped our engineers 2

Top