GarveyUSMC
New member
- Local time
- Today, 05:02
- Joined
- Jan 30, 2010
- Messages
- 5
Problem is I am inputing information to a form and I keep getting:
cannot add record(s) join key of table not in recordset
I know why it is having this problem. I have to hit save on the form to actually make my second table have an entry field made. I found this on the forums:
"Hard to explain quickly without knowing what your form does (or is meant to do), but basically it's this: you've got some Table1 and Table2 working together; they contain related data, and the way a db relates that data is on some key value, usually an ID field of some kind, a field common to both tables. Let's say Table1 is your master table (e.g. a customers table) and Table2 is dependent on it (e.g. an orders table). You can't add an order to Table2 unless the ID field is in the query, because you need to put a value in the ID field in order for the table to accept the data.
For more specific help, please tell us what your form is based on, and what it is meant to do, and look at the record source property of the form and let us know what that says."
Which is what is happening to me. My question is there a way I can redo this so I do not have to have to hit save in the middle of my form before I can complete the second half? If you can break it down Marine style it would be much appreciated.
Semper Fi
cannot add record(s) join key of table not in recordset
I know why it is having this problem. I have to hit save on the form to actually make my second table have an entry field made. I found this on the forums:
"Hard to explain quickly without knowing what your form does (or is meant to do), but basically it's this: you've got some Table1 and Table2 working together; they contain related data, and the way a db relates that data is on some key value, usually an ID field of some kind, a field common to both tables. Let's say Table1 is your master table (e.g. a customers table) and Table2 is dependent on it (e.g. an orders table). You can't add an order to Table2 unless the ID field is in the query, because you need to put a value in the ID field in order for the table to accept the data.
For more specific help, please tell us what your form is based on, and what it is meant to do, and look at the record source property of the form and let us know what that says."
Which is what is happening to me. My question is there a way I can redo this so I do not have to have to hit save in the middle of my form before I can complete the second half? If you can break it down Marine style it would be much appreciated.
Semper Fi
