User Profile
Collapse
-
Yeah I pretty much understood the problem and I was thinking to add 2 extra buttons of add and save for the secondary table. So when I click the add button on top it only connects to table1 and the save button on top also saves only in table1. And the 2 new buttons will add and save in table2. I'll leave the NrCrt(table1) textbox and the corresponding field in table2 visible so that after saving data into table1 the Nr Crt will be visible and can...Leave a comment:
-
2 related access tables connected to one vb form, problem with saving data
Hi, I have 2 access tables (table1, table2), table2 is related to the field "Nr Crt"(which is an AutoNumber) in table1 in a "one-to-many" relation. Table1 is connected to the vb form to textboxes, table2 is in DataGridView. Whenever I try to add data, the AutoNumber is set to -1, so the data from table2 is not saved correctly.I need a code for when I click the Add button the "Nr Crt" autonumber field will automatically...
No activity results to display
Show More
Leave a comment: