Help PLZ : Code Placement Subform

[at_rcc]

Hi Everyone, i am having problem to make nuBuilder do a task. Actually, i have an invoice for a customer, the customer is allocated in a batch and when save button is pressed all the batch allocated should automatically insert the customer in the batch table.

Hereby are the screenshot below:

i want the code so that the user when he is allocated a batch in the invoice form , i want to know where to place the code to insert him for all the batches in the corresponding course in the database table for that course.

i am also including a database scheme to help you understand my system

[admin]

at_rcc,

A few of questions.

Is there a course table?

What table is the Course Details subform based on?

Is the user supposed to pick both course and batch in the Course Details subform?

Steven

[at_rcc]

FOR THE COURSE, i am using the table called product itself, what i want is that when a user select a course in the invoice where it is calculated, in the subform the same course appears and the user is assigned in a batch in the table table tbl_abtch where the batch name is obtained and i wish that the number of student in that batch is updated along with the table tbl_batch_stud where the customer enrolling for the course and the batch name ID is stored in that table.

[admin]

at_rcc.

My suggestion would be to put all the details on one subform.

On the subform tab of a subform object's properties you can define Width.

Then if the total width of the objects in this subform exceed that Width, the subform will have a scroll bar, allowing you to see all objects.

And you won't need 2 subforms on 2 tabs, holding what is essentially 1 record.

Steven