Create a Markdown table of fields from base tables in a FileMaker file.

MD Table of Basetable Fields.txt

Let (
	baseTables = "'" &
	ExecuteSQL (
		"SELECT TableName FROM FILEMAKER_TABLES WHERE TableName = BaseTableName" ;
		"" ;
		"','"
	) & "'" ;
	Substitute (
		",TableName,FieldName,FieldType,FieldID,FieldClass,FieldReps,ModCount," & ¶ &
		",----,----,----,----,----,----,----," & ¶ &
		ExecuteSQL (
			"SELECT '',TableName,FieldName,FieldType,FieldID,FieldClass,FieldReps,ModCount,'' FROM FILEMAKER_FIELDS WHERE TableName IN (" &
			baseTables & ")" ;
			"" ;
			""
		) ;
		"," ;
		"|"
	)
)