Jump to content
Sign in to follow this  
Joseph31

Value List Hybrid

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Thank you got it

Glad you figured it out. Good luck!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.