1:n relation to external linked table

  • Thread starter Thread starter Stefan Wunderlich
  • Start date Start date
S

Stefan Wunderlich

Hi
I have two databases, a client db and a planning db. In the planning db I
need client information which is stored in the client db. I tried to link
the main table from client db in my planning db but I could not set the 1:n
relation type.

Can anybody tell me why it is not possible to set 1:n relation when working
with external linked tables and how to solve this problem?

What I want: dbClient.tblAllClients------1:n-----dbPlanning.tblOrders

Thank you

Stefan
 
Hi Stefan,

If you have something like the following:

dbClient.tblAllClients (ClientID-primary key)
dbPlanning.tblOrders (ClientIDx-foreign key)

then the Relationship wizard would create a 1:n relationship. But keep in
mind that you can't Enforce Referential Integrity with Linked Tables (by
Design).

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| From: "Stefan Wunderlich" <[email protected]>
| Newsgroups: microsoft.public.access.externaldata
| Subject: 1:n relation to external linked table
| Date: Tue, 3 Feb 2004 09:44:30 +0100
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
| Lines: 16
| Message-ID: <[email protected]>
| NNTP-Posting-Host: 212.41.82.242
| X-Trace: 1075797880 newsspool.solnet.ch 128 212.41.82.242
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!130.59.10.21.MISMATCH!irazu.
switch.ch!switch.ch!solnet.ch!solnet.ch!newsspool.solnet.ch!not-for-mail
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.externaldata:48532
| X-Tomcat-NG: microsoft.public.access.externaldata
|
| Hi
| I have two databases, a client db and a planning db. In the planning db I
| need client information which is stored in the client db. I tried to link
| the main table from client db in my planning db but I could not set the
1:n
| relation type.
|
| Can anybody tell me why it is not possible to set 1:n relation when
working
| with external linked tables and how to solve this problem?
|
| What I want: dbClient.tblAllClients------1:n-----dbPlanning.tblOrders
|
| Thank you
|
| Stefan
|
|
|
 
Back
Top