Hi there,
I'm trying to take advantage of the components as much as I can (fun way to work coming from command line ;-))
Now I'm somewhat stuck and am unsure how to continue:
Ich have a DB with multiple tables, with FKs. I am using SELECT * statements to grab the main data (to take advantage of the DBNavigator component to update and insert) and am Using LookupComboBoxes to normalize the FKs. That works nice so far - the stone I encounter though is one specific field that contains a TEXT - an address (so multi-line text).
The LookupComboBox doesn't seem to render newlines, and the memobox can't perform a lookup - is there a way around this which I haven't seen, a component that I can drop in to do this, or do I have to create a seperate logic for this one field?
For more context - I have a DB grid with the main data, on selection of a row all the details are fileld into DBEdits and LookupComboBoxes (those on the resolved FK fields). I hope this make sense.
Best,
Mat