Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Notes 4.51 Combo boxes
- Thread starter MikeTom
- Start date
There's probably a more efficient answer, but you could use a preliminary field to filter your list.
For instance if your Serial numbers begin with an alpha character, have the keywords filter by a choice made by the user. if the SN is egh36x98. The user first enters an "E" to filter the list for all those SN's that begin with "E".
You could also use a range of numbers or a manufacturer.
For instance if your Serial numbers begin with an alpha character, have the keywords filter by a choice made by the user. if the SN is egh36x98. The user first enters an "E" to filter the list for all those SN's that begin with "E".
You could also use a range of numbers or a manufacturer.
- Thread starter
- #3
I didn't mean sort the list. I meant Filter it so that when they enter the manufacturer, your SN list is only created with appropriate SN's. You leave out, for instance all the Dell SNs when they enter HP for manufacturer. Pull into the keyword list only those SNs that are applicable.
If that is already what you are doing and still over 64K, I'd look for another possible filter.
If that is already what you are doing and still over 64K, I'd look for another possible filter.
- Thread starter
- #5
Thats what i am doing. i have a manufacture combobox so when a manufacture is selected i have a dblookup against it to select the sn. the problem is one of the manufacturers has two many serial numbers for the combo box so i get the field 64k error.
- Thread starter
- #7
Their is not another field i can use to filter the serial numbers. what i was thinking of trying is their is an option to use a view dialog for chioces. but when i select this nothing appears in the combo nor do i get a dialog box up. i can not find anything in notes help on this method, i am not even sure if this will solve my problem. it seems what i need to do is find a different method to select the serial numbers other than usig a combobox.
I'm running 4.6 and don't have a problem with the view dialogue.
I created a field and set the default to a prompt text. Set the properties to keyword, editable, view dialogue box.
Selected the database and the view and column.
Worked fine.
How does that compare to what you tried? And will that work for you?
I created a field and set the default to a prompt text. Set the properties to keyword, editable, view dialogue box.
Selected the database and the view and column.
Worked fine.
How does that compare to what you tried? And will that work for you?
- Thread starter
- #9
it was not working for me. but i looked more into it and it looks like it will not work in a layout region. now that i have seen them i will look inyo trying to use it but i dont think it will help me. the fact that you cant have them in a layout region is another problem. you cant create a find button to use in the view dialog and i cant use my find button in the layout region. i shall carry on searching for a way. thanks for you help.
- Status
Similar threads
- Locked
- Question