1. Erik Segerdell
  2. Valentina Studio
  3. Dienstag, Februar 26 2019, 09:26 PM
  4.  Abonnieren via E-Mail
Hello -- We'd like to customize the items in a combo box in a form, so that users will choose from meaningful text labels which would be mapped to the actual values that are recorded in the database. For example, there might a Lab table with 3 rows:

id, name
1, Darwin
2, Einstein
3, Curie

An Experiment table would have a 'lab' field which references 'id' in the Lab table. There will be a form for entering data into the Experiment table. We'd like users to see the items from Lab 'name' in a combo box ('Darwin', 'Einstein', and 'Curie'), but based on their choice, either '1', '2', or '3' would be recorded in the Experiment 'lab' field. Is it possible to set it up this way?

Thanks!
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Erik,

It’s not implemented but we have this task. We’ll try to implement it in the nearest time.
Referenzen
  1. https://valentina-db.com/bt/view.php?id=8271
Kommentar
There are no comments made yet.
Greg_O Akzeptierte Antwort
I've just spend a good few hours trying to get that to work thinking I must be doing something wrong. Turns out it's not possible at the moment :(

I got really excited yesterday when I found Valentina Studio thinking I could create a DB-driven app using the forms functionality. However, the lack of such basic functionality stops me in my tracks.

For example, I need to be able to create a new entry in an Albums table. Any new record in the table need to reference the Artists table. Thy Artists table contains Artist_id field (primary key) and Name. When adding a new album record (Album name, release date, Artist_id) though a form I need to be able to select the artist by his name (e.g. Metallica) but have the Artist_id value (e.g 45) recorded instead so the two tables are linked. I can't expect end users to be looking up IDs whenever they need to update / add new records...

Is there any update on this functionality?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Greg,

It is marked as implemented, I'll add more details shortly.
Kommentar
There are no comments made yet.
Greg_O Akzeptierte Antwort
Great, that's exciting.. will check back in a few days' time...
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories