Layout list

[john9210]

I'm using  FM 15. How can I create a list of layouts and source tables?

[Lee Smith]

Hi John,

Have you ran a Datadase Design Report?

Lee

[john9210]

Yes I do, but the DDR only gives a Layout Hierarchy without the associated tables. I know I can use a database function to create a list of layouts, but I can'f find a function that would list the associated tables. I was hoping there would be a way.

[Tom Assia]

Hello,

by using this file and the ddr maybe you could find a way

You would have to import ddr data in a filemaker file

 

layout.fmp12

[Fitch]

You could loop through your layouts with a script and build your list using

Get ( LayoutName )

and

ExecuteSQL ( "SELECT DISTINCT BaseTableName FROM FileMaker_Tables WHERE TableName='" & Get ( LayoutTableName ) & "'" ; "" ; ""  )

Credit: