Issue 51754 - Dropdown control cannot be correctly linked to form datasource
Summary: Dropdown control cannot be correctly linked to form datasource
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m113
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2005-07-09 12:03 UTC by phiro
Modified: 2006-06-12 16:22 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description phiro 2005-07-09 12:03:34 UTC
This can be reproduced by creating a form with data from a table that is linked
to another table by a Mastertable : Main table relation . For instance the field
mastertable.key_id links to the master table keys with fields
mastertable.key_id, mastertable.key_description. 
In the form.datasource there is only the key_id foreign key. 
By putting a dropdown list on the form i expect to link to the key_id field
while showing the values of the key_description fields. On save the underlaying
key_id of the selected value in the dropdown would be written to the form
datasource table key_id. 
The defect is you cannot. You can show the values of key_description allright,
but  it try to store this key_description value to the form.datasource.key_id is
stead of the key_id from the combobox. 

What did I do: 
- I placed a combobox on the form. The wizard appears.
- I select the master table keys.keys_description as the display field
- I select in the next step "Yes, I want to save it in the following database
field" the form.datasource.key_id (This is where you'd expect to link, or be
able to link, the mastertable.key_id to this field. now it links the
mastertable.key_description field to it. )
- Now the field shows the form.datasource.key_id (Should have been the
description from the mastertable) with a dropdown of all
mastertable.descriptions (Ok) 
- I now select a value from the dropdown.
-When saving the app complains I save the description into the database.

I tried to set the values manualy but came to the same concusion.
Comment 1 christoph.lukasiak 2006-04-24 15:35:39 UTC
clu->phiro: may you attach a sample database (showing your problem)

thx
Comment 2 christoph.lukasiak 2006-06-12 16:21:50 UTC
i cannot repro that in general in current version (src680m171)
Comment 3 christoph.lukasiak 2006-06-12 16:22:59 UTC
no respond -> close

do not hestitate to reopen this issue if bug is still reproducable in current
version

thx