Hi! I need help...
I have 3 tables: Customer, Job Order(main), Job Order Grid.
Customer table fields: c_id(primary key) autonumber, c_name, c_address.
Job Order(main) fields: jo_no(primary key)autonumber,jo_ordered-date, c_id(foreign key)
Job Order Grid fields: jod_id, jod_qty, jod_unit, jod_desc, jod_uprice, jod_amt, jo_no(foreign key).
RELATIONSHIPS: One Customer - Many Job Order(main)
One Job Order(main) - Many Job Order Grid
Using ADODC
My form: jo_no-textbox
c_name-combo box
c_address-textbox
jo_ordered-datepicker
Im using datagrid control for my Job Order Grid.
My problem is that I don't know how to accomplish this task. If you click a save button on the form, how would it save the data in the 3 tables?
If you don't get what I mean I would like to send you my vb project to see it for yourself.
I hope you could help me...
I have 3 tables: Customer, Job Order(main), Job Order Grid.
Customer table fields: c_id(primary key) autonumber, c_name, c_address.
Job Order(main) fields: jo_no(primary key)autonumber,jo_ordered-date, c_id(foreign key)
Job Order Grid fields: jod_id, jod_qty, jod_unit, jod_desc, jod_uprice, jod_amt, jo_no(foreign key).
RELATIONSHIPS: One Customer - Many Job Order(main)
One Job Order(main) - Many Job Order Grid
Using ADODC
My form: jo_no-textbox
c_name-combo box
c_address-textbox
jo_ordered-datepicker
Im using datagrid control for my Job Order Grid.
My problem is that I don't know how to accomplish this task. If you click a save button on the form, how would it save the data in the 3 tables?
If you don't get what I mean I would like to send you my vb project to see it for yourself.
I hope you could help me...