Form not accepting data

[rahultiwari]

Hi
I have two tables. bug and drift. They are linked by a field called sample.

When I try to create a form using these two tables and include the sample filed of the bug table, the form will allow the data to be changed only on those field which are in the bug table and I cannot do anything with the data of the drift table. if i include the the sample field of the drift table, i will get an error message "microsoft jet engine cannot find a record in the table bug with key maching field(s) 'sample'" , when i try to save the record.
No fields are locked in any of the tables and forms
Any one knows what could be wroing here.

Regards
Rahul

 

[maxmangion]

ideally you shouldn't be bounding your forms directly to a table(s). Instead create a query with your necessary fields from your tables, and then bound your form to this query.