The Microsoft database engine cannot find a record

[accessbuddy]

I have a table called Process Prices. This table stores all the set up cost and prices for each process. The Quote form has 10 process combo boxes which means a repeat of the option to choose a price from the Process PRices. Hence, i have made another table called Process Names which stores teh information that is selected for each of these processes per order.

However, I am now experiencing an error "The Microsoft Access database engine cannot find a record in the table 'Process Price' with key matching field(s) 'Process'.

I am not sure what this means and what I have to do!



Thanks!

[ranman256]

Which is it: Process Prices (table) or 'Process Price' (error) ?
I'm guessing spelling error.

[John_G]

When are you getting this error? Is it in response to a selection from only one of the combo boxes, or any one of them when you select a particular value?

The text of the error suggests that you have a relationship somewhere with "enforce referential integrity" selected, and the integrity is being violated.

John

[accessbuddy]

Which is it: Process Prices (table) or 'Process Price' (error) ?
I'm guessing spelling error.

Hi!

It is Process Prices, sorry!

[accessbuddy]

When are you getting this error? Is it in response to a selection from only one of the combo boxes, or any one of them when you select a particular value?

The text of the error suggests that you have a relationship somewhere with "enforce referential integrity" selected, and the integrity is being violated.

John

I am getting this error when i select something in the combo box. How would I design it so that the process 1, process 2... process 10 on the Quote Form all gain information from the Process Prices table?

Thanks!

[accessbuddy]

This is an image of the relationships if that helps?

[ItsMe]

I suggest that before you build any forms you study up on Relational Databases and how to use an RDBMS. What you have there is not Normalized.
https://www.accessforums.net/tutoria...ase-45451.html