It may be useful to explain your table design.
You have a client database (table) that has a desire (client::want)
You have an inventory database (table) that has a have (inventory:: have)
You want to match your client::want to your inventory::have
Is this close to your setup?
Yes it is.
"Yes it is."
Umm, this is less than an useful description of your table layout.
My customer table consists of several fields: And the inventory table consists of these:
Phone # Model
Date Ext Color
Time Int Color