Review Primary key and foreign key.
If you have designed your tables and relationships based on your business rules, then this should be handled by your database structure.
To find all info about a Customer, I would think CustomerID would be the means.
In your set up it seems
Code:
A Customer may have 1 or Many Quotes.
And this would represent a 1 to Many relationship between Customer and Quote.
Perhaps there is more to the issue than has been described.
Can you show us screen capture of your tables and relationships (jpg)?