
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
-
@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.
-
@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..
-
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