hi.i have problem adding record into access database because these tables i've created has relationships.i need to add record (from a single vb form) into 2 different tables. these 2 tables refer to the same record id actually.but first i need to add record into the first table because then only will the database automatically generate an id for the record.next, i need to add record into another table(which refers to the same id).i got a run-time error that says:
"You cannot add or change record because a related record is required in Table '1' "
how do i add record in a proper manner then,any suggestion?
thanx in advance..