Is it possible to fill a choice list from a table? Thanks
For example:
i have a customer table with a sub table linked called “dogs” so every customer might have more than 1 dog.
Anothe table is called activities, this table contains customer with their dogs performing their activities. How can I have a field where I’m able to select a dog for a particular activity? Is it possible to load a list of dogs in a field to make a choice? Thanks
-
Hi,
A link from dogs table to activity will help you choose from a list of dogs for an actitity.
Regards,
Sakshi- Ninox
-
Hi, could you please explain this more detailed? or i'll try to ask my question.
In the field I need to choose (dropdown list) one of the values (number) from other table's row. How to make it?
Thanks in advance,
Tomas
-
Hi,
If you go to "Edit fields" you can make connection between the tables by draging the one tables name from the right hand side column into the middle column of your fields:
Best, Jörg
-
@Tomas .. what Jörg and Sakshi are explaing is that the "lookup" and assignment is possible. It will not be the "choice box" UI form object, it is a relationship between two tables. I believe there is a requested / pending enhancement to source a choice box from a query at somepoint in the future.
-
Hi,
I think I have a question about this too...
In the field "Films", instead of having to click on the search icon, open a window, select the film, etc., I would like the content of the table "Films" to be displayed directly in the field as a drop down list. Is this possible?
Thank you,
Etienne
-
@Etienne
You can display the contents of the Films table in a "view".. but clicking one will only drill into the film record, not populate the reference. There is a Change Request to provide the ability to populate a drop down from a select / view... but I am not aware of the implementation timeline.
-
So you cant make a drop down list from a field in another table?
-
@mjrudolphi ... not at this time.. but as you can tell . this is a much requested enhancement.
There are other threads that outline how to use the associated table and "after update" trigger to populate a reference.. so .. In essence, it is a "pop up selection" .. not a "drop down list box".. Still very effective..
-
Wow. That seems like a pretty basic feature for a database/dashboarding software. Does Ninox publish a roadmap?
-
any update?
-
any update to this function to re-populate a drop down combobox based on another drop down combobox selection?
-
Yes, indeed it is a VERY much requested feature! ....
I use another dBase design app as well that has that feature ("Picklists"). It gives you quite a few choices re: how the field displays the data on your 'forms' (e.g. 2-3 columns, etc.). Unfortunately the app is 'single user' only - it doesn't have the cloud/share component . I can't wait for that feature *please*. ke
-
Not sure if this helps. Table a is AssetMaster which has a popup for related table AssetClass. Table b. is AssetCategory which is keyed on AssetClass and has multiple values per AssetClass value. When adding the AssetCategory reference table to AssetMaster I created the following constrait and only see AssetCategory values for the selected AssetClass of the AssetMaster.
a.AssetClass.Class = b.Class
