Hello,

I am a developing a runtime database with several fields with drop down value lists. The user will need be able to define and alter those value lists (data includes “Customer type” and “dep. to which account.”)

In FM 6, it was easy enough to put the fields in a separate file where all the values could be stored, separated by carraige returns, in a single record, and have the main file refer to the fields to determine the value lists. In FM 8 Advanced, I do not see how to do this and have been unbable to come up with any alternatives.

Also, After I link the table that holds the source fields for the value lists to the destination table (relationship using the "=" comp. operator), I can no longer add additional data to the source fields. In the fields place is

Any help would be greatly appreciated.

Edited September 26, 200520 yr by Guest

I have attached a file that I think gives you what your looking for. Although I may have missed something!

Value_List.fp7.zip

Thanks, Paul. I will check out the file later today and let you know how it works for me.

---

Thanks again! This file does settle my problem. It appears I was on the right track, only I've been messing around with relating the values table to the data tables.

Edited September 26, 200520 yr by Guest