>Trey,
>
>I really should have said "have a matching record in the _Clients_ table."
>
I knew what you meant anyway <g>
>Sherry has an ORder_id in the clients table which means that she's keeping a name for each order, or not as the case may be.
>
>Most of us would have the client being the parent and insist on having a client set up before they could place an order, but she may have a system where they are "cash" customers and don't always get all the client details - though I don't know how you would send out a letter without details.
>
>Maybe Sherry should re-assess her design if things aren't too far along.
Right you are. Once again, I assume a little too much.
Insanity: Doing the same thing over and over and expecting different results.