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

Hi John,

Have you ran a Datadase Design Report?

Lee

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.

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

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: