Solved

Referential integrity enforcement via linked table

Posted on 2004-04-02
3
490 Views
Last Modified: 2008-03-06
I am placing a relationship between "tblpaymentsreceived" and another table linked from another Access database that includes a joining reference field.

I reconciled both tables to ensure that data in the joining field was reflected in both tables and linked them.

A "One-to-Many" relationship was highlighted in the dialog box but I cannot check the "Enforce Referential Integrity" box.  I have tried inputting an incorrect reference number in "tblpaymentsreceived" and no error message appeared.

Can I not enforce this referential integrity rule because of the linked table?  If so, how can I discipline input (can I place a combo box in the "tblpaymentsreceived" field that only reflects reference numbers from the linked table)?

0
Comment
Question by:MidlandR
3 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 10740072
Hello MidlandR,

Referential integrity must be enforced in the database where the tables are held (that is - the backend database)



Pete
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 400 total points
ID: 10740091
no, you cannot apply REFERENTIAL integrity rules on LINKED tables.  The rules MUST be established on the Actual Physical tables, themselves.


As for using a Combobox based on the Linked table, to enforce the relationship in code, that is the proper solution fopr this problem.

AW
0
 
LVL 54

Expert Comment

by:nico5038
ID: 10740156
As stated above, this isn't possible.

You basically have two options:
1) Move "tblpaymentsreceived" to the other database
2) "Force" the referential integrety from your application, however when the user(s) have access to the tables, this can fail :-)

Nic;o)
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question