Foriegn key concept not working with check table

Advertisement
Consider, there are two tables like emp_personal and emp_official.
In emp_personal table , the fields are empid, empname, dob for example. In this table, empid is the primary key field.
In emp_official table, the fields are empid, dept, designation for example. In this also, empid is the Primary key.
Now we relate these two tables using the foreign key relationship.
Now, emp_personal is the Check table .
emp_official table is the Foreign key table.
for example create some 5 records in the emp_personal table .
Table : emp_personal :   Primary Key - empid
empid       empname       empdob             Status 
   1            AAA            1.1.1990           Record saved successfully
   2            BBB            2.2.1990           Record saved successfully
   3            CCC            3.3.1990           Record saved successfully
   4            DDD           4.4.1990           Record saved successfully
   5            EEE            5.5.1990           Record saved successfully
Records are saved in the table : emp_personal.
Now, Am tryiing to create records in emp_official table.
Table : emp_official :   Primary Key or not a Primary Key - empid
empid        dept              designation        Status 
   1            Dept1           S.E                   Record saved successfully
   2            Dept2           S.SE                 Record saved successfully
Now, if am  try to create the record which is not in the table emp_personal, which has the empid = 6.Normaly it'll not allow us to create the record 6,
But the think is its allow to create.
   6            Dept6           P.M                  Here also status is record saved
Kindly help me out.
Advertisement

Replay

did you read the documentation for "screen check"/"check required" flag in foreign key screen? it says:
Flag for check of input values wanted on screen
Definition
This flag defines whether an input check should be executed on the screen for the field. This definition is applies to all the screens on which the check field appears.
The check can be switched off again with the flag set for certain screens (by canceling the flag 'For. key' in the attributes of the corresponding screen field).
Use
Switching off the screen check can be useful in the following cases:
if for test reasons there is to be no check
if a semantic foreign key is used for the aggregate definition but no input check is to be executed.

TableChanged() does not work with parrent table reference

Hi, I used this example http://www.javalobby.org/articles/jtable/ where the cells refocus after updating, but I have rewrote it to my needs and the program throws nullpointerexception when I update any cell:( here is the tableChanged part of code:   

"member of " not working with nested table of dates

Can someone explain why this doesn't work. The last select does not return any row. When trying the same with a table of number, it works fine. drop table test; drop type date_tab; create type date_tab as table of date; create table test(dates date_t

Satellite Pro A200 - Fn keys does not work with Windows Vista

Hello, I own a Satellite Pro A200-PSAE7E and a retail license for Windows Vista Ultimate 32bit (with SP1) installed on it. Before installing Vista, I upgraded the BIOS to the most recent version available on the Toshiba site ([http://it.computers.tos

Web Service Test in SE80 does not work with internal Table

Hello, I have created a web server based on a function module. It works fine when the server is invoked from outside (.Net or SOAPUI). However, when I test it in SE80, (open the Server and then F8), it shows error message:      Access to the table re

.click on row works with php table - does not work with javascript table.

Howdy, I've run into a very interesting problem today, and I hope you'll be able to help me. I have a page in which the top is php to read a table from the server, and post the table as the html page is being built. The data come up as a table, and e

Scaling with key commands not working with objects or text frames

Suddenly, I can no longer hold Shift+Option+Command to proportionally scale anything in InDesign CC 2014. Any suggestions?Which file do I want to trash or rename?Read other 10 answers

Is there a keyboard shortcut to launch firefox 3.6.3 with windows vista? Hot key (ctrl + alt + key) does not work.

The hot key (ctrl + alt + key) does not work. This is in Windows Vista.Thank you Morbus and Cor-el, for your prompt replies. Here's what I did: I've placed the Firefox icon in the quick launch toolbar. So I right-click this firefox icon>Properties>S

Keyboard keys are not working

Im on mac OS X 10.6.8 several keyboard keys are not working. For instance the at symbol is not working or question mark and random other punctuation keys. The problem started after running some code from terminal to trun off mouse acceleration and th

Mbp numerical keys are not working

my macbook pro was using last one year now the numerical keys are not working find a solutionIt sounds like what I have seen multiple times on a device with moisture damage. Even sitting on a bathroom counter during a hot steamy shower or bath can ca

Entry does not exists in check table -- Validation

Hi friends..,   I am able to create new entries in my table with INSERT statement through a function module. But, the problem is.., I am having one key field in my table, and T1(another table) is check table for this. So while creating the entries th

Certain Keys are not working. Have tried everything!

Hi, I was hoping I could get some help with this issue that I've had for a long time now. My "x", "s", "w" and "2" keys have not worked for the longest time now. I have an HP Probook 4510s. Things I've tried: - I've

My Macbook Pro (bought in 2013) function keys are not working

My Macbook Pro (bought in 2013) function keys are not working. The function keys ie the volume and brightness are not working at all both with one single tap and with the function button. I have checked the settings for the keyboard but nothing seems

Key is not working

I downloaded Windows 7 with SP1 Debug/Checked Build 64-bit from msdn, but this version is not listed when I start setup. I tried Ultimate N and Professional N and I get windows key doesn't work with current windows SKU. What is my key valid for? (got

Function keys are not working correctly

I've been looking all over the various threads and I can't find an answer that solves my problem. Here are the details: I bought the computer in the U.S. where I live. I have a iMac 2.4GHz intel Core 2 Duo  EMC 2133 with a 20" screen. Bought it new i

Why CUA (Release 7.00) is Not Working with Old Clients(Release 4.6C, 4.5B)?

Hi all, We have CUA (release 7.00) that is not working with older release clients. I implemented 2 release 7.00 clients to CUA; they both work fine. However, when I implement some older release clients (like, 4.5B, 4.6C, 6.20 and 6.40) to CUA,  I can

My Time Capsule does not work with existing WiFi

Following a question solved on March 24 by LaPastenague, but gone bad again. Apple AirPort Time Capsule I felt the need for a physical backup of my data, as I would not completely trust the different clouds. I use, and have used Dropbox for 4-5 years

Firefox does not work with yahoo mail, why ???

for some reason firefox does not work with the new Email window on yahoo.com All the other browsers work with yahoo mail just fine!! Are you working on a fix???''ralphieboy [[#question-1022015|said]]'' <blockquote> for some reason firefox does not w

Site list update not working with TED and Zenworks for Servers

Product: Zenworks for Desktops 7Sp1 and Zenworks For Server/TED 7Sp1HP5 Subject: Site list update not working with TED and Zenworks for Servers , all on Linux Description: We have an exiting environment with 6 ZfS Servers and now we brought up a new

Database Mail not working with SQL Server Agent

I'm running SQL Server 2005 Standard edition 64 bit with SP2 on a 64 bit machine.  Database mail does not work with SQL Server Agent.  When I configure SQL Server Agent to use database mail the test email button is greyed out and inactive therefore I