Home » Developer & Programmer » Forms » Non Base Table detail Block
Non Base Table detail Block [message #618792] Tue, 15 July 2014 11:29 Go to next message
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
Littlefoot
Messages: 21806
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.
Previous Topic: How to change color of a Push Button
Next Topic: Initial value should be dynamic based on the available list element months
Goto Forum:
  


Current Time: Thu Mar 28 07:45:13 CDT 2024