I have a ‘2’ columns table where are stored a few jpg color squares (10*10 pix) and their “description” (red square : important, blue : cleared, etc)
On an form based on a different table I have placed 2 MediaType fields based on the same data provider.
One of the fields is a valuelist with the descriptions that returns the jpg file, the other shows the jpg.
I can make the selection (the list is ok and the right jpg is shown) but the combobox field always shows the first value of the list.
In my case, the problem might be solved using the bgcolor of the field (if I can manage it independently for each record in list view, I didn’t try yet).
But it could be usefull, for example, for browsing pictures, no?
those media fields both work on the same dataprovider of that form i take?
then if you select one with the combobox you see the selection change in the other. But later on the combobox doesn’t select the other?
I think that can be a problem yes. Because i have to test it but it can be that the combo selection process can’t handle blobs right (only strings/numbers ect).
Yes both field work on the same dataprovider (mediatype) of that form.
I don’t try to show a blob in the combobox, only text.
It almost works : I can browse the list, pick one value and the expected picture is shown in the other field.
But the combobox, after focus is lost, always shows the same text (the one of the first record of the table the valuelist is based on).
The problem has disappeared BUT only for the time of the current session.
If I make selections every thing seems to work fine but if I restart the app or go to dev mode and back the comboboxes are all (I use this in table view) set to blank (with or without allow empty value checked).