ContributionsMost RecentMost LikesSolutionsRe: Formula to look up a corresponding field from a related table?Worked like a charm!!! Yes, the Code is a text field.What you suggested basically created a surrogate field to stand in for the Code field that is being manually entered.Once I set up the relationship as you described, I made the Description field on the data entry form a lookup field where the reference is the formula text field and the value is the Description from the related parent table. Thank you so much!I've been racking my brain for days trying to figure out how to make this work.Much appreciated.Re: Formula to look up a corresponding field from a related table?Thanks, Mark.You're correct -- each code in the Codes table is unique and the relationship was backwards.I have deleted the relationship, changed the key field in the Codes table to the Code field, and re-created the relationship so that one Code record is related to many Data Entry records. Now, back to the data entry form.I do NOT want the user to select a code from a drop down list.There are over 14,000 codes so that would be impractical.I want the user to be able to manually enter the Code (which they will know), and I want an adjacent field in the Data Entry form to return the Description of whatever Code was manually entered in the previous field. Does that help clarify what I'm trying to do?Formula to look up a corresponding field from a related table?I'm a new QuickBase user. This is probably a simple question, but I don't know how to construct a formula to look up a corresponding field from a related table. I have a parent table and a child table with a one-to-many relationship. The child table contains only two fields: Code and Description. There are thousands of records in the child table, each containing a Code and a corresponding Description. The parent table has a form. One of the fields in the form allows users to manually enter a Code. Another field in the form -- which is a text formula field -- is where I want to enter a formula that will return the corresponding Description based on the Code entered in the first field. Both the Code and Description fields from the child table are part of the relationship to the parent table. I'm not sure what functions in Quickbase will produce the desired result. I've scoured online help, the knowledge base, the community, etc. for several hours. The closest I've come is finding a response saying yes, QuickBase can do this, but no instructions on how. Can someone please help? Thanks in advance.Re: How can I remove ""None of the above"" from radio button options without making the field required?Yes, I asked how to avoid making it a required field.Re: How can I remove ""None of the above"" from radio button options without making the field required?nmHow can I remove ""None of the above"" from radio button options without making the field required?The response is either "yes" or "no" and those are the only two radio buttons that should be available. Thanks. [Edit: Added screenshots. The first shows the form as it is now, the yes/no multiple choice inputs available, the switch to radio buttons, and the resulting form where "None of the above" appears as an unwanted radio button.]