Jump to content

Drop Down Field that looks up a record


JohnOMalley
 Share

This topic is 5602 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I want to be able to have a field that will look for a specific record in a table. I would like for it to be a live search (meaning as I type it is filtering down to the specific record ID) in this field. When It has uniquely identified it, I would like to hit enter and then the record and its related records appear in the portal. If I was doing this in MS Access - I know a bad word but one with which I am familiar - I would create an unbound control that would lookup a record and select the record and its associated records in the related table. Can someone give me the structure to follow to replicate this. I do not like the idea of using find to do the same thing.

Link to comment
Share on other sites

I'm not sure if you are setting it up right, or missed the fact that it works based on [color:blue]previously entered data in the field. In this way, it is similar to how Excel does it, only better.

HTH

Lee

Link to comment
Share on other sites

This topic is 5602 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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