Forum Discussion
EmberKrumwied1
Qrew Trainee
It is just a text field. I have since learned, from a different source, that what I am hoping to accomplish can not be done. This is a text field and even though it is set to be unique, the table holds over 300 entries. Pull down lists are limited to 100 entries, and that's even if the field could be converted to a pull down option. Seeking other solutions to achieve similar result.
------------------------------
Ember Krumwied
------------------------------
------------------------------
Ember Krumwied
------------------------------
BlakeHarrison
4 years agoQrew Captain
I would encourage you to start by making the Company data a separate table.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- EmberKrumwied14 years agoQrew TraineeThank you Blake, the Company is a separate table, its just that the table holds over 300 companies.
------------------------------
Ember Krumwied
------------------------------- MarkShnier__You4 years agoQrew LegendWhat Blake means is that you should be setting up a relationship where One Company has many "records" ie whatever your detail records are now.
Is you company field on the details record a multiple choice field with he choices pulled from the Companies table? ie how does it work in data entry on a record now. Where does the company choice come from there?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- EmberKrumwied14 years agoQrew TraineeThat is what I have. I have many tables (all holding only unique information). Just to list a few:
Entities (main table)
Partners (main table)
Formations (linked to Entities on Entities key field EntityName)
Partner Interest (linked to Entities on Entities key field EntityName; also linked to Partners on key field PartnerName)
Transfers (linked to Entities on Entities key field EntityName)
For my Entities table I was trying to create a form that would allow a user to use a pull down menu list and select a SINGLE Entity record to view. The Entities table contains over 300 rows of records, with no Entity duplicated. The EntityName field is a text field so that a user can enter in a new record. When I use EntityName as a filter on a report and select the option to ask the user what is displayed is a text box that the user must actually type in characters in order to filter the list. What I was hoping to be able to create was to present the user with a pull down list whereby they can SELECT a specific entity to view.
I am finding that pull down lists are limited to show only 100 options so this wouldn't work for me. I'm currently investigating other filtering options to help my user jump to a specific entity without having to scroll down the list or advance to an additional page just to find the one entity they need to work with.
------------------------------
Ember Krumwied
------------------------------