From: John W. Vinson on
On Tue, 19 Jan 2010 05:21:01 -0800, Peter <Peter(a)discussions.microsoft.com>
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?

Are you having a problem doing so? What you're suggesting is perfectly
routine. Just be sure that TableB Field A is a Long Integer.
--

John W. Vinson [MVP]