If you change the pop-up menu to a drop-down you get another option that allows you to create.. You can also specify other..
let me know if this is what your wanting..
i selected the dropped down list instead and allow editing of value list is grayed out. This is how im building the value list. This field is coming from the parent table to my child/table layout and it's still only showing me two of the 10 companies. i want it to show the 10 companies and at the same time allow it to change within any of the 10 companies. im going to be here all night please help me if you can i been working on this for hours.
here below is the two tables
the popover button-->pop-up menu setup configuration
the value list configuration for the pop-up menu
the companyIDfk field highlighted in the popover setup window is coming from the parent table called Company that has relationship to the members table from companyIDpk to _companyIDfk.
i need the members to be able modify between the 10 companies in the company table and not just the two companies that is showing up so far. in another words the members should be able to switch back and forward between the 10 companies and not just those 2.
Thank you for your post.
Set the Pop-up menu or Drop-down list to the Company Name field. Then, once the company field is selected/modified, use a script trigger to set Company::_Company_IDpk to Members::_company_IDfk.
Or in your original value list set up specify that the first field value be from Company::_Company_idpk instead of from the fk field in members.
It's due to specifying that the values come from members in field 1 that is limiting the value list to only values from the members table.