Relationships between tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Glenn Aitchison (glenn_at_nospam.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 18:37:11 +1200

Hello.

    I have a table - lets call it table A and we have another table called
table B

    I have a relationship between the two tables and i am curently browse
fields in table B.
   If a field is blank in table A then the cursor is placed at the end of
table ... why? and how do i get it to go to the top??
  As soon as I turn off the relationship everything works fine but I end up
with the first entry in table B in a grid list....

eg.

  grid

tableA - customer information
tableB - area and there id (location)

col1 - tableA
col2 - tableA
col3 - tableB

col1 col2 col3
"joe bloggs" "1 test drive" areaid

if col3 is blank then when browsing tableB cursor is placed at end of
table - not start.

Thanks in advance

Glenn

Relevant Pages

  • Re: Cursors (again)
    ... Insert into TableA ... > what the values in tableB, ... > Unless I am missing something, here is a cursor that does the same thing ... > open cTableB ...
    (microsoft.public.sqlserver.programming)
  • Re: using select into in a stored procedure.
    ... How do I replace TableA with values ... >INSERT TableB (ColA, ColB, ColC) ... >> I have a stored procedure in which I am using a cursor ...
    (microsoft.public.sqlserver.programming)
  • Re: Adding records to a .dbf file
    ... Create Cursor TableA (Field1 C(3)) ... Create Cursor TableB ) ...
    (microsoft.public.fox.helpwanted)
  • Re: Which column is taken in JOIN with multiple columns and different content ?
    ... Both of these tables contain a column with name "col1". ... FROM tablea a, tableb b ... select tablea.col1, col2, col3 ...
    (comp.databases.oracle.misc)
  • Re: TEXT column manipulation
    ... > I need to combine all the data from TABLEA into TABLEB. ... > this by using a cursor and using the UPDATETEXT command but it's very ...
    (microsoft.public.sqlserver.programming)