By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,153 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Query error message

stonward
100+
P: 145
Hi folks,

does anyone recognise the problem that this error message shows?

-cannot add record(s);join key of table 'tbl_Orderdetails' not in recordset-

My two sale tables, tbl_CustomerOrders and tbl_Orderdetails share the OrderID field (invoice number). Naturally this is a one to many, the field being a PK on CustomerOrders and FK on 'details...

On my other forms, when you type in the invoice number, it auto'ly follows to the other table...

Thankyou!
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


stonward
100+
P: 145
S'ok Guys,

Think I've sussed it....needed to put in the field that links the main and sub forms...

Fear not. I'm sure I'll be proper stuck again later!

Thanks,

Stonward.
Sep 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.