Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Relational Databases
Expertise: Beginner
Mar 28, 1997



Building the Right Environment to Support AI, Machine Learning and Deep Learning


I am using a DBgrid. I have defined two NEW Persistent fields as lookup fields. In the Columns editor, I added them to the grid display.

Those two fields are connected to two separate tables, tblCategory and tblItems. tblCategory is the MasterSource of tblItems. The idea is: select the category from column 1 in DBGrid (thus narrowing the items that can be entered to just the items in that particular category), then select the items from column 2.

My problem is, when I click on the DBNavigator to insert a new record, then do the above procedure, the ComboBox displays the correct category and item, but when I click on my selection in the list, it seems to enter a blank record (hang on, it gets better). I complete entering the data for the rest of the fields and post the record.

Once I have posted the record, the selections I made become visible. I'm convinced the data selection is there but I CAN'T SEE IT. Why?

I believe the problem is the fact that one of your columns belongs to another table. The DBNav works its one DBNav to one DataSource to one table, so you won't get synchronized behavior.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date