Re: DBGrid problem


Sorry, but i've already posted this question on another ng, but i hope this
is the correct ng :)


This is the situation:

- One access db with 2 tables:
maintable: id: (unique key)
frequency : string
name : string
surname : string
secondtable: id: (unique key)
freq:string;

Now I've a form with a dbgrid linked to a datasource,linked to the
maintable, and 2 adoconnection ("adomain" and "adosecondtable")
You should only be using one TadoConnection for both datasets


What i want to do is quite simple... on the dbgrid i want a combobox on the
"frequency column"(picking values from the second table,field "freq"), but i
don't want a master-detail relationship; so when i select the string from
the combobox, that string will be stored on the maintable (and NOT linked to
the second table using "id").

Define a lookup field in the main table with the looklist pointing to your
second table. The Grid should automatically give you the combobox you are
looking for
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: AssertionFailure null id in entry
    ... private String MYROW1; ... However, as stated before, when I have a duplicate unique key, it ... EntityMode entityMode) ... Now Hibernate needs to do 2 things - it needs to persist an object to the ...
    (comp.lang.java.programmer)
  • Re: Using multiple keys within Map object
    ... My problem is that the unique key is 3 double values when non of them is unique by itself. ... There is a function to convert a floating point value to a string which is its ... Matlab help says that num2str is doing that but I've found that it cuts the accuracy dramatically. ... and data classes and value ...
    (comp.soft-sys.matlab)
  • Re: AssertionFailure null id in entry
    ... private String MYROW1; ... However, as stated before, when I have a duplicate unique key, it ... Now deleted the id autoincrement field from my mapping class and used ...
    (comp.lang.java.programmer)
  • Re: AssertionFailure null id in entry
    ... private String MYROW1; ... However, as stated before, when I have a duplicate unique key, it ... Now deleted the id autoincrement field from my mapping class and used ...
    (comp.lang.java.programmer)
  • DBGrid problem
    ... frequency: string ... secondtable: id: (unique key) ... don't want a master-detail relationship; so when i select the string from ... the combobox, that string will be stored on the maintable (and NOT linked to ...
    (borland.public.delphi.database.ado)