I created 7 tables for an invoice management solution.

I find the seven layouts. But, only the primary key and Fk fields appear on the layouts.

Why do the other fields like First name etc do not show in the Customer layout?

M K

Do they show in Layout Mode? How many Table Occurances do you have?

In Layout Mode, double click one of the fields and see if say Table listed in the Display Data From: is the one you thought the fields are in.

You could post a copy of your database so we can look at this with you.

Lee

Thanks Lee for your kind reply, I have been pulling my hair out.

How do I attach my FM file?

I explained it here awhile back, see if it helps you. Link

Let us know if you need more help.

Lee

It is strange that 'EXPENSES' layout shows the fields. I have 7 tables and 7 Table occurances.

I also checked the display dialog box.

What gives?

I am attaching the file: MarsInvestigations

I tried to zip the file but it zips to .zipx

Thanks

MK

MK,

You can manually add fields to existing layouts using the field tool in Layout mode.

-Barbara

Thanks, but I was curious why this is happening?

Thanks

MK

You mean why it's NOT happening - see the second row in paragraph 2:

http://www.filemaker.com/help/html/preferences.26.3.html#1027658

Thanks for the reply.

Actually that's the first thing I checked.

The preferences are set to show newly added fields.

M Khan

Edited December 28, 200916 yr by Guest

Attach a copy of your file so that we can see what you are looking at.

The .zipx extension is new to me,

I'm not a Windows person, but there must be a way to change to just plain zip. We have a lot of Window users and this hasn't been a problem to others that I'm aware of.

HTH

Lee

The preferences are set to show newly added fields.

Note that this only adds newly defined fields to the current layout. If you add fields to another table (i.e. not the table of the current layout), these fields will NOT be automatically added to any layout.

Here is the .zip file.

Thanks

MK

Edited December 28, 200916 yr by Guest
please re-attach file..

I get an error on your attachment. We seem to be having a recurring problem with this feature. I'll contact Admin and let them know.

Try sending it to me using the Private Topic and we'll see if that helps.

Lee

Hi :

The file did not upload because there was a glitch in the upload process, acc. to Ocean West. I am uploading it again.

Returning to the original problem, the solution is simple: I can insert fields.

But I am curious about the fundamental aspects of a database. If fields start missing in a critical item, then what?

M K

Ch07_Mars_Investigations_Start.zip

Edited December 28, 200916 yr by Guest
spelling. paragraph

Fields aren't missing. Fields are not displayed on a layout. You need to add them to the layout. There is no fundamental aspect of the database to worry about.

You've been told about the FM Preference that adds the fields to a layout or not--in both this forum and FMI's.

I see that you're still confused. Why and about what?

Your Patience paid off, the attachment works. Hooray.

I reviewed your file, and it sure looks like the "Add newly defined fields to current layout" wasn't checked when the file was being created, even though it is checked now, and it worked when I tested it.

Returning to the original problem, the solution is simple: I can insert fields.

Yep, you can drag them onto layout one at a time, or you could just create a New Layout for each of the current one's and select all of the fields you want on the New Layout in the creation of it.

HTH

Lee

Edited December 28, 200916 yr by Guest

Thanks for your patience.

It appears that the db works on your system but not on mine.

I checked again. In the preferences - layout the item Add newly defined fields to current layout is checked in all the 8 layouts.

I still see only the Pk and fk fields.

Regards

MK

Enabling this preference does not add the fields to the layout that were defined during the period this preference was disabled. You need to add these fields manually. Any new fields that you define will be added to the layout.

Oh, Now I get it! Thanks so much.

MK