Jump to content

How to list all fields in related databases.


This topic is 6539 days old. Please don't post here. Open a new topic instead.

Recommended Posts


First of all, welcome to these Forums.

What do you mean by unique ?

The FieldNames( ) would return a list of all fields in a specific layout in a specific DataBase.

So if you set a Layout "AllFields" in each database, and drop all the fields there, you should get a list of those fields.

Then List Db1 &"

Link to comment
Share on other sites

Slightly different technique:

Use Status(CurrentFileName) and put a calc field in each DB:

"AllFields" = FieldNames(Status(CurrentFileName), "")

You can then view each file's AllFields in one of the files using relationships.


Link to comment
Share on other sites

  • Newbies

Thanks for replying.

I am a FMP user without prior scripting experience. Can you please explain your replies for my experience level? Thanks.

The 10 related databases were created by someone else. I need to merge my existing data from my single database into those 10 related databases.

As a first step toward matching the fields in my single database with the fields in the 10 related ones, I need to generate a (printed) listing of all of the fields in the 10 databases.

What I have done is to print the field definitions from the other person's main database. But it would be better if I could get a single list of the unique field definitions in all 10 databases.

By "unique," I mean that if any given field (e.g., student ID number) is included in more than one of the 10 databases, the list that I want would include that field only once.

Thank you again.

Link to comment
Share on other sites

You might want to have a look at this sample file:


It's an automatic documenter utility. As well as doing other things, it will grab a list of all field definitions in the current set of open files. You can then search and sort by file name to get a list of the unique names.

Note: to eliminate the duplicates you will need to run a duplicate finder script like the one given in the Filemaker manual on page 10-13.

Link to comment
Share on other sites

This topic is 6539 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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.