Solved

Referential integrity enforcement via linked table

Posted on 2004-04-02
3
492 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

752 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