Re: Rebuilding Relationships

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 12/07/04 

Date: Tue, 07 Dec 2004 09:58:20 -0600

Specifying relationships in the front end does do something.
It confuses you by misleading you into the mistaken belief
that you actually did something, when all you actually did
was draw some lines between some boxes. Furthermore, if
those lines are different than the ones in the back end,
your queries will also be confused into thinking they have
to perform Joins differently than the way they were
specified in the back end. 

-- 
Marsh
MVP [MS Access]
FBxiii wrote:
>Oh, I see.
>
>So, if I have related the tables in the backend, and create a new 
>relationship in the frontend (mirroring the relationship at the back), it 
>actually deletes the relationship from the frontend, but the relation still 
>exists?
>
>Ahha!  I think I understand.  Does a relationship created in the frontend 
>actually do anything?
>
>
>"Douglas J. Steele" wrote:
>> The relationships must be in the back-end: relationships in the front-end
>> don't do anything.
>> 
>> That having been said, relinking the tables shouldn't do anything to the
>> relationships.
>> 
>> 
>> "FBxiii" <FBxiii@discussions.microsoft.com> wrote
>> > I have created a front/backend system.  The front detects changes in the
>> > backend and then re-links all the tables.  Unfortunately, this removes the
>> > relationships between the tables.  There is 1 'central' table, used for
>> > tracking the data items passing through the DB.  Several other tables are
>> > linked to the tracking table via a unique identifier (Primary key).
>> >
>> > How/if, using code, do I re-create the relationships?  Ive got the
>> > re-linking bit down to a tee, but all the indexes, etc seem to mess
>> up......