john9210 Posted September 10, 2018 Share Posted September 10, 2018 I'm using FM 15. How can I create a list of layouts and source tables? Link to comment Share on other sites More sharing options...
Lee Smith Posted September 10, 2018 Share Posted September 10, 2018 Hi John, Have you ran a Datadase Design Report? Lee Link to comment Share on other sites More sharing options...
john9210 Posted September 10, 2018 Author Share Posted September 10, 2018 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. Link to comment Share on other sites More sharing options...
Tom Assia Posted September 10, 2018 Share Posted September 10, 2018 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 Link to comment Share on other sites More sharing options...
Fitch Posted September 10, 2018 Share Posted September 10, 2018 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: Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2055 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now