Can a value list use BOTH "custom values" and "values from field"?

[AnnieT]

I would like to create a value list that lists all the records for one table (values from a field) AND also includes "Add New" and a seperator at the top of the list (custom value). If someone chooses "Add New" I'll have a script that runs.

Can this be done??? Thanks in advance!

[bcooney]

Rarely can something flat out NOT be accomplished in FM. However, to take what you say literally, no, you cannot have a value list based on values from a field and have the ability to select Add New from the value list. However, you can have an Add New button near the value list, that'll take the user to the table and create a New Record. This can be done in a popup window.

value lists are often used to populate foreign key fields. I rarely create value lists that are from values in a field (as that won't include a key field). I use value lists that consist of an ID and a second descriptive field, and only show the second field.

[IdealData]

Not quite - but then also...

You could have 2 instances of the target field on the layout, each with their own drop downs. Set one field to have the drop down presented automatically and the other to "include arrow to show and hide list" - hide one field behind the other and then you give the illusion of two lists on the same field.

[AnnieT]

Thanks bcooney...I am currently using an "add new" button with a popup window and using foreign keys to populate the value list with a second descriptive field. Just thought there might be some sneaky way to accomplish this :)

[AnnieT]

Thanks IdealData...I love sneaky maneuvers like that but after playing around for a while I haven't gotten it to work smoothly. I'm going to stick with the traditional way of doing things and a script that asks the user if they want to select from the database or add a new record.