|
Home > Archive > Programming with dBASE > March 2006 > ComboBox DataSource versus Datalink
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
ComboBox DataSource versus Datalink
|
|
| Steve Hawkins 2006-03-17, 11:23 am |
| For some reason, I've completely forgotten how to do this (haven't needed to for awhile). Hoping someone can point me in the right direction. Can't find a direct reference to it in the knowledge base.
Form with a combobox with a datasource using a calculated field (last name, firstname, etc). When user saves the record though, I don't want to save lastname, firstname. I want to save the file number for the person selected. Drawing an absolute blank
here. What's the best way to do that? Do I need to somehow use the OnChange for the combobox? Thanks for your input.
| |
| Ken Mayer [dBVIPS] 2006-03-17, 1:23 pm |
| Steve Hawkins wrote:
> For some reason, I've completely forgotten how to do this (haven't needed to for awhile). Hoping someone can point me in the right direction. Can't find a direct reference to it in the knowledge base.
>
> Form with a combobox with a datasource using a calculated field (last name, firstname, etc). When user saves the record though, I don't want to save lastname, firstname. I want to save the file number for the person selected. Drawing an absolute blan
k here. What's the best way to do that? Do I need to somehow use the OnChange for the combobox? Thanks for your input.
You should be using a lookupSQL for this, shouldn't you?
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
|
| Steve,
Ken's right. Use a lookupsql and datalink only no datasource. If you have Ken's dBase book (a little promo for you Ken), take a look at the topic Lookupsql in the index.
Rick
Steve Hawkins Wrote:
> For some reason, I've completely forgotten how to do this (haven't needed to for awhile). Hoping someone can point me in the right direction. Can't find a direct reference to it in the knowledge base.
>
> Form with a combobox with a datasource using a calculated field (last name, firstname, etc). When user saves the record though, I don't want to save lastname, firstname. I want to save the file number for the person selected. Drawing an absolute blan
k here. What's the best way to do that? Do I need to somehow use the OnChange for the combobox? Thanks for your input.
| |
| Steve Hawkins 2006-03-19, 11:07 am |
| Of course Ken is right <g>. For some reason I hadn't thought of that one. Been awhile since I had to use it. And thanks for the plug on the book. I'll likely buy it at some point in the near future.
Rick Wrote:
> Steve,
>
> Ken's right. Use a lookupsql and datalink only no datasource. If you have Ken's dBase book (a little promo for you Ken), take a look at the topic Lookupsql in the index.
>
> Rick
>
>
> Steve Hawkins Wrote:
>
ank here. What's the best way to do that? Do I need to somehow use the OnChange for the combobox? Thanks for your input.[color=darkred]
>
| |
| Steve Hawkins 2006-03-19, 11:07 am |
| Indeed Ken, indeed. Thanks so much for your reply. Can't figure out for the life of me why I didn't reach that conclusion. I think I may have been emotionally scarred from my early dBASE days when I had SO much trouble getting that to work <g>.
Ken Mayer [dBVIPS] Wrote:
You should be using a lookupSQL for this, shouldn't you?
| |
| Ken Mayer [dBVIPS] 2006-03-21, 3:25 am |
| Steve Hawkins wrote:
> Indeed Ken, indeed. Thanks so much for your reply. Can't figure out for the life of me why I didn't reach that conclusion. I think I may have been emotionally scarred from my early dBASE days when I had SO much trouble getting that to work <g>.
Well, sometimes it's the old "forest for the trees" issue. I've had
plenty of times when someone suggested something and I slapped my
forehead and said "D'oh! So obvious!" ... <g>
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
|
|
|