Moving database to Admin

As a follow up question. I want to make a database that I can reference to create a list in another section but it seems to only create a one item list rather than the whole list I created in the reference database. What am I not groking?

I can and I will!

In the section editor I create a multi record editor with a table name of measures_database.

I modified that section editor by adding a list field which had the data I wanted. In this case its a list of measures such as:

cup
ounce
gallon
etc.

Then I went to the section editor to add this field to another editor and "hopefully" pull the list from measures_database.

Does that make sense?

Hi cohagan,

Ahh, I understand. If you don't want to copy-and-paste your list options around, you may consider setting up a separate section for your options and then use the "Get options from database (advanced)" list field feature.

Your measures_database section only needs to have one field in it: a text field (let's call that "label".) Having a dragSortOrder field can be convienient. You won't want a list field in measures_database; instead, create records for each of the measurements (by going to the section and clicking Create.)

Now you can create a List Field in other sections which get their list options from the measures_database section. To do so, set the List Field's "List Options" to "Get options from database (advanced)", set "section tablename" to "measures_database", use "label" for list option values, and "label" for list option labels.

I hope this helps! If I misunderstood your question, please feel free to ask more! :)

Thats done it. Thanks again for the excellent insight.