SwitchBoard with Filter and Button + More actions

[DreamerArgentino]

Hi all!
I have this base: (see attached): and I would need that: the data I choose in the Switchboard is "injected" in the field "ID- Dept "of the table" TBL-Students "when choosing initially, and simultaneously create a new record in the form" FRM-Students01 "

I hope you can help me! Thank you
DreamerArgentino.-

[UnklDonald418]

To open the form document FRM-Students01 ready to enter a new record, open the Form Properties dialog for "MainForm" and on the Data tab change the Add data only property to Yes.

The form document Initial-Switchboard01 makes things needlessly complicated.
Since the selected value for field "ID- Dept" is ultimately stored in TBL-Students why not just use a list box on "MainForm" of FRM-Students01 to select a Department.
If you want to force the user to select a Department when entering a new Student record, an easy solution would be to add a NOT NULL constraint to the column "ID- Dept"

To do that you will first need to either edit all the existing student records and add a value in the "ID-Dept" column, or delete those records. Then execute the following SQL command

Code: Select all   Expand viewCollapse view

ALTER TABLE "TBL-Students" ALTER COLUMN "ID-Dept" SET NOT NULL;

Then if the user attempts to enter a new student record without selecting a Department they will get an error dialog.