Non Base Table detail Block [message #618792] |
Tue, 15 July 2014 11:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/62ae4481ea2228b76ebfec3585752697?s=64&d=mm&r=g) |
Asfakul
Messages: 43 Registered: July 2014
|
Member |
|
|
Hi , I am trying to create a Form where the user will be able to select a department and in the detail block I will show the followng columns and user will be able to select a particular Emp# using Check Box and delete it.
Emp# FName LName DepartmentName
Any Idea on how to solve this ?
[Updated on: Tue, 15 July 2014 13:07] Report message to a moderator
|
|
|
Re: Non Base Table detail Block [message #618815 is a reply to message #618792] |
Tue, 15 July 2014 15:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
That would be a master-detail form. Departments = master, employees = detail.
Though, there's a far simpler way to do that: let the Data Block wizard create just one database block: employees. Run the form, execute query. Set focus to an employee you want to delete and push the "Delete" button in Forms' toolbar.
Basically, you don't have to write a single line of code, Forms does everything for you.
|
|
|