When I build a table to use for a drop down menu eg Mr, Mrs,Ms or Monday Tuesday Wednesday etc, it would be nice to be able to add this data into the component. That way it will me ready to go when installed.

Sorry should have put this in new functions [MOVED]

For lists like Mr, Mrs you can use the enumeration data type

zutiste

Can you give an example of how to use the enumeration... because last night was trying to find a good use ofr it, but I still did not get it... thanks

well, not sure I understand your question because it looks very simple to me.

for example, a table with first name and last name. you can add an enumeration field with the values "Mr, Mrs, Miss". just edit the field to specify the values.

I guess it's good for values that won't change.

If I understood right... I could use it to make to fields like "Pending", "Canceled" and "Sent" for orders for instance?

If that's the use of this field, I think is nice...

yes, correct.

- if the data won't change
- if there is no extra information associated to the data

ie :
-> "Pending", "Canceled" and "Sent" is set for eternity and does not need any extra information
-> List of prices : it might change
-> List of countries : there might be associated information like biggest cities, international country calling code, time zone, etc

Thanks mate... I got it now...

I found a good use for it now... I was doing in another way, but using this feature, makes things easier...

Nice one zutiste this has made life so much easier.
I was using the foreign key method to show info from another table.

The problem I had with foreign key was, the id was stored in the database instead of the value.
i.e Mr=1 Mrs=2 Ms=3.

I want to be able to export the data to an excel file so that would have been a problem./

Very happy I asked the original question now or I wouldn't have learned this.

Karma added, cheers