Database table & view


K

Ken

After I reverse engineered my database I have one sheet for the entire
database. I would like to create show the relationships for each table on an
individual sheet.

How do I reference all the tables in the table and view area?
 
Ad

Advertisements

K

Ken

Al,

Thank you for the inforamtion. I have already completed all those steps.

My first sheet contains all the tables and their relationships.
Unfortunately with the number of tables I have in the database it is not as
useful as I would like.

I started to make a seperate sheet for each table. I drag a table to a
blank sheet, then right click and select show releated tables.

After the 5th table I tried to record a macro to create the following
sheets. The macro did not show how to access the Table & View panel.

My goal is to write VBA code to select each table, put the table on a new
sheet, show releated tables, and as the last step re-layout the sheet.

Thanks.
 
Ad

Advertisements

A

AlEdlund

The datamodeler is a closed solution (part of the data is in a proprietary
format internal to the tool) with no published api. By design they sometimes
cripple the ability of the macro recorder to capture the calls to the addin.
Sorry,
Al
 

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


Top