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.
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
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).
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.
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:
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
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
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
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
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
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
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
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
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. 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
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
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
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
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
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
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
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