Prev: Referential integrity. AutoNumber.
Next: what is the best way to check 60 different conditions in my if
From: BruceM via AccessMonster.com on 19 Jan 2010 08:48
It should work. Were you unable to create a relationship with RI? If so,
did the tables contain data before you attempted to create the relationship?

Peter wrote:
>Hi all..I want to create a one-to-many relation between:
>
>Table: A. Field : A (AutoNumber) (Primary Key)
>
>One to many relation
>
>Table: B. Field: A (Number)
>
>Am I thinking wrong here? If I cant Enforce Referential Integrity in this
>case should I still create a relation, but without RI?
>
>Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

From: BruceM via AccessMonster.com on 19 Jan 2010 09:26
As Arvin pointed out, and which I should have considered before my initial
response, be sure the field in Table B is not only number, but that it is
Long Integer. Long Integer is one of the choices for Field Size, at least in
pre-2007 versions of Access.

Peter wrote:
>Hi all..I want to create a one-to-many relation between:
>
>Table: A. Field : A (AutoNumber) (Primary Key)
>
>One to many relation
>
>Table: B. Field: A (Number)
>
>Am I thinking wrong here? If I cant Enforce Referential Integrity in this
>case should I still create a relation, but without RI?
>
>Thanks!

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

From: David W. Fenton on 19 Jan 2010 14:04
"BruceM via AccessMonster.com" <u54429(a)uwe> wrote in
news:a258da6b70f41(a)uwe:

> As Arvin pointed out, and which I should have considered before my
> initial response, be sure the field in Table B is not only number,
> but that it is Long Integer. Long Integer is one of the choices
> for Field Size, at least in pre-2007 versions of Access.

And the reason you choose Long Integer is because that's the data
type of an Autonumber field, which is nothing more than a Long
Integer field with a special kind of default value.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
 | 
Pages: 1
Prev: Referential integrity. AutoNumber.
Next: what is the best way to check 60 different conditions in my if