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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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