| need Urgent help please [message #175701] |
Mon, 05 June 2006 00:06  |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
Urgent help
Sir I have master detail table
Master table
Vno code disc.
PK
=-===============
1 33 dd
2 45 gg
Detail table
Vno dept amount
Fk Fk
1 1 44
1 2 55
1 6454
Department table
Dept title
PK
1 fsdf
2 slkjdfs
3 sdfj
sir dept code I get through lov and title of department I move in other column in detail section
sir data feeding time no problem lov give title and move to deptname column is type is display
but sir I not give dept no in all record some is blank it my requirement that department need amount I post dept no otherwise I save data without deptno
sir when I retrieve record or view time I write code in post-query trigger for get department title in deptname column
my query
select title into :deptname from department where deptid=:deptid;
my system not show those record who have blank dept no
display only dept fill record
and if I hot use post-query then give all record but I need with determent name out put
please sir give me idea how I get department title with query
thank
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
