Is it possible to edit records from (or add records to) a VL that is linked from another table?

34 people have glanced at this question. Is the problem

a) this question is already covered in the published literature (you dummy),

it can't be done, or

c) do y'all not understand the question?

My vote goes to c). It pays to spend a bit more effort on the description of the problem.

Let me explain more. I started with a value list of document types (warranty deeds, quitclaim deeds, mineral deeds, deeds of trust, leases, etc.). Eventually there will be about 50 different kinds of doc types, so I wanted them sorted. That way when I'm looking for a Warranty Deed, I will find it conveniently located at the bottom of the list. So I created another table with a list of doc types and referenced it from the value list. Now they are sorted; however I don't seem to have the option of adding additional doc types to my list.

This is a new database and eventually the list of doc types will be very stable. At that point I will not need to either sort it or add to it. For now I could periodically sort it in another program and put the sorted list back into a value list. Or I could do something else, but with the list in a different table, I seem to have the worst of all worlds (except for sorting). Is there a way to add my new doc types to the remote table on the fly while I'm building the database?

If, as I understand, your value list is defined to use values from a field in a table, the list will be automatically modified when you add/delete/modify a record in that table (and commit it). Sorting (alphabetically) is also automatic.

To quickly add values as you go, you could create a script like in the attached file.

Values.fp7.zip