This is a multi-part message in MIME format.

------=_NextPart_000_0045_01C1E2E3.5AEFE7D0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi

Is there a common reason why sql inserts work OK when numbers are usied 
for the primary - foreign keys but when a text field is used I get 
'record required in related table' error.

Andrew

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "AAustin" <plant-tech@x...>
Subject: [access_asp] PK - FK- Number or text


: Is there a common reason why sql inserts work OK when 
: numbers are usied for the primary - foreign keys but when a text 
: field is used I get 'record required in related table' error.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Not that I'm aware of.

Cheers
Ken

I had some problems with both DELETE and INSERT with
Access working with database information.  But I did
it to myself, when the insert statement is used to enter
data and you try and find it later 'TEXT' values.

I ran into problems with the insert format putting a
leading blank in text field [my fault] and when I
went to find it there was no leading blank in my input
string and alas no match was found.  Not sure if related,
but this has been my past experience.

I was told TEXT can be sticky if your not careful.  You
must be very precise in how you write data if you hope
to find it later.....

Regards,
Chuck


>From: "Ken Schaefer" <ken@a...>
>Reply-To: "Access ASP" <access_asp@p...>
>To: "Access ASP" <access_asp@p...>
>Subject: [access_asp] Re: PK - FK- Number or text
>Date: Sat, 13 Apr 2002 16:40:05 +1000
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "AAustin" <plant-tech@x...>
>Subject: [access_asp] PK - FK- Number or text
>
>
>: Is there a common reason why sql inserts work OK when
>: numbers are usied for the primary - foreign keys but when a text
>: field is used I get 'record required in related table' error.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>Not that I'm aware of.
>
>Cheers
>Ken
>
>




"Racial interaction is described by Physics,
for every action there is an opposite
reaction.  We hate them, they hate us, and
we hate them back. And there you are, we are
trapped by mathematics."
    -Londo B5

http://aa8vs.dhs.org:81/aa8vs


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.