I had created a database in access for customers to look some goods up of ours now we were going to buy the runtime's for access but this was way to expensive so i decided to give it a shot with delphi. I never tried databases using delphi But i managed to get something running. I used a dbgird,adotable & datasource compentent and i got one of the tables from my ms access mdb file in the grid.
I noticed some things :
in the mdb file i have several tables linked to each other (relations) but when i look at the dbgrid i only see the id's instead of what this id is represented by in another table so my question is how can i get the grid to show not the id but the name of what the id is (so it should be looked up in another table).
Another question is
how do the DBlistboxes & DBcomboboxes work ? i never could get em running, in access i had a form wich i want to remake in delphi that showed 3 listboxes each wich showed data from a table how can do this in delphi ?? i nvr could get it working (so example source code is appreciated)
also i'm looking for sites that explains this, in particular with mdb (access) files