Do both layouts refer to the same table or different tables?
Assuming different tables for each layout, the field formatted as a pop up menu should be a field from the 2nd table, not the table of names.
Don't know why you are getting a ? here. If you place a copy of this field next to the pop up menu, but format it as an edit box, does it also show the "?" ? What do you see when you click or tab into the edit box?
the layout is attached to tblschoolList and the popup menu is also attached to tblschoolList. The fields on the layout are attached to tblSchools.
The popup menu is doing the job and refreshing the form with correct data it only has an issue with one record (not a specific one / whatever one selected)
Yes it was there for a while, the ? appears in the tblschoolsList and when I place a field on the form it shows up there. And then the whole record just disappeared.
Kind of an xFiles moment
Thanks in advance
is tbleSchoolList the only table in your database? Or do you have a separate table for the menu's value list? Keep in mind that layouts and tables are different things here.
Sometimes a question mark where there should be data indicates a problem with a field's index and the index is what a table base value list like this uses to produce the list of values. You can try rebuilding the field's index to see if it makes any difference.
To rebuild the index of a single field,
- open Manage | Database | Fields and double click the field
- Use either the storage tab or the storage options button to turn off indexing.
- Exit Manage | Database, then return and turn indexing back on.
You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.
If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:
With the file closed, select Recover from the File Menu.
Select "Use advanced Options"
Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".
tblSchoolList is a table for the menu and tblSchools is the table to be either updated or display of data. tblSchoolList is a direct copy of tblSchools. In the relationships I have created a join between a unique field destNo mirrored in both.
Do I still go with the rebuild
Don't know. It can't hurt.
How exactly did you do this? "tblSchoolList is a direct copy of tblSchools"
I can think of several ways to read that and they don't all have the same results. You might have two boxes on Manage | Database | Relationships, but only one table listed on the tables tab. Or you might have two tables listed in the tables tab.
both tables listed in the tables tab and both in relationships
Ok, then let's check these details and see if anything I list differs from what you have:
The value list is defined to list names from tblSchoolList.
On a layout to TblSchools, you have a text field defined in TblSchools formatted as a Pop up Menu that uses this value list.
Make sure that this field is from tblSchools and not from tblSchoolList. You may need to enter layout mode and double click it to check.
If you used a field from tbleSchoolList instead of tblSchools, this would explain why selecting a name in the pop up changes a name in tblSchoolList. It doesn't explain the ? you saw, but first things first.
I think I have got it.
the layout is correct as you stated, with data from tblschools
The popup menu was displaying data from schoolsList and value field from schoolList.
This meant that the first school selected was replaced with a ? and data was not refreshed in the layout based on the selection from the popup menu.
What I did was change
the popup menu to display data from tblSchools and leave the value field pointing to schoolList.
It works perfectly.
Was that the right thing to do??
What table does this layout refer to in Layout setup... (Show records from)?
The menu's field and the layout should refer to the same table.
both menu field and layout are referring to tblSchools
Then you should be all set.
the pop up menu is working correctly and changing the related name field but it is not updating the rest of the layout (like address fields). Made a new layout with a portal style and same issue
There are two basic ways to link your tables so that selecting a value causes data in other fields on the layout to appear. This thread describes both approaches. The consequences of each choice are different so read and compare the options carefully.