I've been fiddling around with a database for a while, and I've figured that if you make a value list using match fields in related tables you can create new records in the "daughter" table via pop up menu. But I've also discovered that this can only be done if you have fields in the "daughter" table in the layout of the parent table. But what if you wish to create a value list that only affects one field (the one in the list) and allows permanent addition of new values?

Joel

In the Edit Value List window set the radio button to Use Values From Field and specify your "one field". Set your "one field" Field Format to Pop-up List and specify the newly defined Value List.

I understand how to set a value list; that's not the problem. The problem exists in making one that can have values added (by other) and kept in the menu, without having to have other fields affiliated with the table.

i.e.

two tables

SOURCE

OUTPUT

both have, for sake of simplicity, one field

VALUES

.. the field is the match field between the two tables. The idea is for someone working from the OUTPUT table to be able to add records to the SOURCE table via pop up menu using a value list defined by VALUES (from SOURCE). This works, if you have another field from SOURCE in the OUTPUT layout, ie

SOURCE has two fields, VALUE and DESCRIPTION

OUTPUT has one field, VALUE

OUTPUT's layout is

VALUE (pop up menu using value list defined by SOURCE::VALUE)

SOURCE::DESCRIPTION

If you enter a value for the second field, a new record will be created. However, if no value is entered, no new record. I was wondering if there's a way for a user to force FM7 to accept the new value defined by "other" in the popup menu without having to add a secondary field.