Jump to content
Sign in to follow this  
Bill Fair

Cannot see fields

Recommended Posts

Newby, I am reading FileMaker Pro 9 Bible.

Have created the test Data Base and some fields do not appear in tables.

Suggestions appreciated.

Edited by Guest

Share this post


Link to post
Share on other sites

Go into layout mode, and add the fields that are "missing" to the layout.

Share this post


Link to post
Share on other sites

I can see that this might work, but why would I have to do that. Some of the fields created in the Manage Database window appear in the Layout?

Share this post


Link to post
Share on other sites

Are you saying that the fields are not in the tables or not in the layout?

If you mean not in the layout. When you go into Manage Databases from Layout A which refers to Table A and then switch to Table B and add a field in Table B it will not be included on Layout B for Table B. So, you must then add it to the layout.

If you are adding a field to a table and then it is not there be sure you are saving saving the tables correctly.

Edited by Guest

Share this post


Link to post
Share on other sites

When you first create tables, a layout is added for each table. But, I believe that when you go back into Manage Database, any addtl fields that you add will not necessarily be added to existing layouts.

Share this post


Link to post
Share on other sites

I believe that when you go back into Manage Database, any addtl fields that you add will not necessarily be added to existing layouts.

That depends on the setting in application preferences.

Share this post


Link to post
Share on other sites

Yes, but, the checkbox says "add newly defined fields to current layout." As I pointed out if you go to Manage Databases from Layout A/Table A and add fields to table B when you close the "Manage Database Screen' you will be brought back to Layout A and the the newly defined field will not show on either layout. Am I missing something?

Share this post


Link to post
Share on other sites

Yes, but, the checkbox says "add newly defined fields to current layout." As I pointed out if you go to Manage Databases from Layout A/Table A and add fields to table B when you close the "Manage Database Screen' you will be brought back to Layout A and the the newly defined field will not show on either layout. Am I missing something?

Yes, you are correct. If you are currently viewing Table A and you add a field to Table B, then no fields will be added to any layouts regardless of the preference "Add Newly Defined Fields to Current Layout" current status. FileMaker only adds fields to the currently viewed layout if:

  • a. You are viewing a layout showing records from a table occurrence of the appended table
  • b. The preference "Add Newly Defined Fields to Current Layout" is enabled

Both items must be true.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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