compare field data in two tables

[vbaInet]

If you were going to work on coding what was explained in post #5, I could have guided you as you go along.

All; I created a sample database that seems to work with code and design flaws. It has to be something with the data. I'll have to find whats wrong. Please can someone review and make suggestions for a redesign and maybe I would get some time to redesign this flawed database. smh.

I'm sure that JLC can advise when he's next online.

 

[JLCantara]

Attached is a possible and ugly solution to your issue. One major problem with your DB schema is that your records are not uniquely defined. So I am proposing a suffix to make the records unique. Of corse there is an other possibility: a quote table, a subquote table and then the quotes records. Losts of coding fun...

Have a look to this solution and don't be shy to comment...

Good luck, JLC.

 

[slimjen1]

Sorry for the delay; I was away for a few day. I am looking as the database and will get back with findings tomorrow. Thanks for all you assistance.