Delphi Pages Forums  

Go Back   Delphi Pages Forums > Delphi Forum > General

Lost Password?

Thread Tools Display Modes
Old 08-11-2018, 11:35 AM
Marsheng Marsheng is offline
Senior Member
Join Date: Nov 2008
Posts: 314
Default Update 2 fields with DBlookupComboBox

I have ListField of names RaceClasses for a table racebike. The dbLookupComBox uses this RaceClasses list for the drop down.

The problem I have is, if the RaceClasses name is edited, the combobox does not find the original name and then comes up blank.

A way round is to use the RaceClasses Listfield and RaceClassID as the key field. That way if the name is changed, the RaceClassID does not.

The issues with this is, the tables now have the RaceClassID and not human readable one. There must be an easy way to update the RaceClassName in table bike from the corresponding name with RaceClassID once a selection is made.

The record pointer on RaceClasses seems to be set the the string list and not the table row so simple racebikeRACECLASSNAME.asString:= RaceClassesRACECLASSNAME.asString does not work.

Basically I want to update 2 fields with a dbLookupComboBox.
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump

All times are GMT. The time now is 06:59 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.