| Form syntax [message #150430] |
Wed, 07 December 2005 18:33  |
1821
Messages: 40
Registered: November 2005
|
Member |
|
|
Hey guys, I am i currently trying to add values into a field on a form that is a non base table field, this is on a master detail form. I can do it on the master form by adding a new text icon and then using the code below as a trigger. However on my detail form i want to do the same kind of thing but i need to use multiple joins in the were statment. But with the colon syntax im not sure how this would work. Any advice would be great. Thanks.
begin
select dept_name
into :employee.dept_name
from department
where department.dept_no = :employee.dept_no;
end;
[Updated on: Wed, 07 December 2005 18:46] Report message to a moderator |
|
|
|
| Re: Form syntax [message #150440 is a reply to message #150430] |
Wed, 07 December 2005 19:47  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
In which trigger did you put this code?
Have you defined the 'relations' between your two blocks?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
