strange error?

[JaredNJames]

hi, i have two three tables linked, tbl_invoices is to linked to tbl_invoice details and tbl_service details as one to many relationships.

tbl_services lists the parts and prices for use in tbl_service details.

the probem is, when i open the form for invoicing which has tbl_invoice details and tbl_service details as subforms, and click on one of the subforms to enter details, it gives me the following error which i have never seen before:

The Microsoft Access database engine cannot find a record in the table 'tbl_services' with key matching field(s) 'Service Name'.

any help?

jared james

 

[Newman]

Can you post a copy of that form with the needed queries(if any) and tables?
Have you made a correct father/son relation between your subforms and your main form?
Also, you seems to have used the tables instead of a query. This is to be avoided. And you shouldn't use spaces in names of tables. Use an underscore or just attach both words using an uppercase to delimit the words. Sometimes Access stops reading after it tumbles upon a space.

 

[JaredNJames]

hi, sorted it now,

jjames

 

[Newman]

Glad to hear it.
Would be nice if you could post what was the error and how you correct it. Someone might run into the same problem and he would be happy to see the solution.