Value List Hybrid

[Joseph31]

The Setup:

Field Called "Prepared_For"

Value list from table "Prepared_For"

I know how to make a simple pull down list and I know how to make a script that adds a new entry to the table called "Prepared_For".

What I want to do is combine this into one -- Let me explain.

When you click on the field "Prepared_For" it brings up the list that you can choose from -- this works. Now if the name does not appear on this list then I would like to just be able to type the new name into the field "Prepared_For" and have it added to the table "Prepared_For" as a new entry.

Can this be done with a script on the cell and what would it look like?

Thank you

Edited May 19, 2009 by Guest

[tv_kid]

Hi Joseph

You don't need a script to accomplish this, just set the value list to use values from the field in question for all records. Then, when you type a value into that field it will automatically add it to the value list.

Does this make sense?

[Joseph31]

No sure if this makes sense. Can you expand on this? I know value list but how can just typing in the field add a record in the list?

Also, when there is already a name in the field and you want to go to the record to see more detail how can this be done without a script.

Thank you

[Joseph31]

Thank you got it --- Now it makes sense...

Good thinking...

Thank you

[tv_kid]

Thank you got it

Glad you figured it out. Good luck!