bruceR

This is a long standing issue with the difference in behavior between drop down lists and popup menus.
 
One approach is to change the control style of the field to be a pop-up menu.
 
However, you can't tab into a pop-up menu (on the Mac anyway)

Nothing special required. Dialog mode not required. Just choose the new window script step with the "Advanced" options and turn off the zoom area.
 
There is no special memo or secret handshake.

Though a calc field would work, and could be a good idea, you can do this with a standard find.
 
Note that the @ character in find mode can be used to represent any single character.
 
In my example, I have phone numbers formatted to use 12 characters:
 
###-###-####
 
Therefore, entering find mode, putting in 12 "@" characters, choosing omit, and performing the find, shows me all records which do NOT have 12 characters in the phone number field.

No, you don't have to import. If you want the song value list to be based on the song table, then base the value list on the song table. Maybe this will help?
SwingamajigMusicB.fp7.zip

Not sure what you mean by nothing happens.
As written it is an endless loop that will do nothing after the first time through.
 
It looks like you forgot to put a go to next record, exit after last statement just before End Loop.

There are zero records in the table for the second layout. 
 
Make a new record.

Set as stored field. Why do you perceive this as a problem?

That is normal and is a new feature of 12.
 
It is controlled in Layout Setup, by whether you have set the checkbox "Delineate fields on current record only"

"So what would the script look like?  I've tried some of the following but most won't allow them to be inputted, saying the table cannot be found"
 
There is no example in your file of a script where you try to set a field.
 
But now there is.
SOAP.zip

1. That function does not give the correct result. You want this:
 
MonthName (Date_Petition_Verified_1750_DAJ) & " " & Day (Date_Petition_Verified_1750_DAJ) & ", " & Year (Date_Petition_Verified_1750_DAJ
 
2. We would have to see more of your paragraph format. You may want to use let statements and substitution, for instance. Or - supposing the above calc is defined for the field LongDate then your paragraph would be something like:
 
Dear <<ClientName>>: Congratulations, our records shown that on <<LongDate>> you won the lottery again!

Or: in Script Manager, select all, print, choose print to PDF.

It isn't clear what you're doing or why; but you misunderstand the nature of global fields.
 
There is only one instance of a global field and that instance exists whether you have any records in the table or not.
 
You only need to use set field. Your script needs to do this for each field you wish to clear.
 
Set field [ gDate; ""]
Set field [ gSomethingElse; ""]

Check the bottom of the Script manager window, notice Import Script icon, positioned next to last bottom right.

For instance...
TabControlPlayground2.fmp12.zip

"SELECT "Tab Names"[17] FROM T14_PREFERENCES"

I agree completely with Lee; your structure needs to change.
 
However, you could use an auto-enter calc like this to prevent entry of more than two lines.
A user might enter a third line; but it won't be accepted.
 
LeftValues( Self; 2)