Is it possible to fill a choice list from a table? 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

@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