Re: parent column in child row

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank (frank_at_frank.com)
Date: 06/03/04 

Date: Thu, 3 Jun 2004 20:36:42 +0200

Is this question so difficult or is it impossible what I want? I can't be
the first one to bump into this problem. Plse tell me if it is not possible
then I can look into another direction.
Frank

"Frank" <frank@frank.com> wrote in message
news:c9i8nv$7vc$1@news3.tilbu1.nb.home.nl...
> Hello,
> I have a dataset with 2 tables and a relation (parent - child). I linked
> that ds to a datagrid. Shows everything fine (very little coding for such
> functionality!).
> But.. in the child row I want to show a column of the parent. Example:
> orderColumn shows customerId and I want the customerName which is located
in
> the parent.
> How do I do that?
> Thanks in advance
> Frank
>
>

Relevant Pages

  • Re: parent column in child row
    ... the first one to bump into this problem. ... Plse tell me if it is not possible ... in the child row I want to show a column of the parent. ... > orderColumn shows customerId and I want the customerName which is located ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cascading deletion
    ... one would be to create a stored procedure to do the deletes. ... Then the stored procedure would first delete the child table rows, then delete the parent table row. ... Create Table FooOrders (OrderID int Primary Key, CustomerID int Not Null, ...
    (microsoft.public.sqlserver.programming)
  • Re: Foreign Key Problem
    ... SELECT * FROM dbo.Customers AS c ... vor allem wenn es viele Parent Zeilen sind): ... WHERE CustomerID = @CustomerID ...
    (microsoft.public.de.german.entwickler.dotnet.vb)
  • Re: Access 2000 - Create a Dependants Table
    ... a Dependant would only have 1 parent. ... Parent and Dependants (Family Members) table so we can track what Members ... CustomerID ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Emergency horse shit shovelling.
    ... dickless. ...  After all, if you want to take me to a ball game, the least ... you could do is be social when you bump into me. ... Not having been a parent ...
    (rec.skiing.alpine)