Skip to Content
0
May 26, 2020 at 12:04 PM

Find the Relationship between tables using the VBA scripts Power designer

190 Views

Hi All

I wanted to explore the the Meta Model /reference object /tables in a diagram Using VBA scripts to find the relationship between tables

I can get the references by

Open the model and get the references by using the below statement

Set Model = PD.OpenModel(strFilename)

Set Module1.PD = PD

Set Module1.Pmodel = Model

Set ref = Pmodel.References

Now I need to go through the object model and get the parent table , child table , relationship type( Identifying /non Identifying) , null ability, Cardinality etc. I went through the docs , could not find. Can anybody help

Ani