HandOfCode Posted January 12, 2011 Share Posted January 12, 2011 Basically what I want to do is a name based auto-complete edit-box (or something similar) that allows users to start typing in a name and of course suggest the correct name (the list of names can/should be pulled from the existing contacts table). When the user confirms the name I want the ID associated with that name to be put into the foreign key field (not displayed on the layout). The layout itself is based on a "Teams" table which has "Team Members" which is a "Contact". The only field shown on the Teams layout is a first+last name calculated field. Teams: _TeamID TeamMembers: _TeamID, _ContactID Contacts: _ContactID The "ideal" solution would be a field that shows a dropdown where as you type the dropdown's value list starts to filter based on what you type, not a "go to" auto select. I apologize if this is the wrong sub-form. (please move it to the correct one) Link to comment Share on other sites More sharing options...
HandOfCode Posted January 25, 2011 Author Share Posted January 25, 2011 For those wondering, in the end I gave up and went with a pop-up style auto-filtered-as-you-type portal (ala nightwing) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4839 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 accountSign in
Already have an account? Sign in here.
Sign In Now