I have a large number of suppliers that all assign me a different
customer number. Does anyone know how/where I can record this
information? I need to include the number on things like my purchase orders.
The obvious place for such an attribute is with the "party_relationship"
(although since this could conceivably be multi-valued, a new table ala
"employment" would be better).
A short-term hack would be to simply store the information as a
"party_attr". For example, if my customer number with supplier XYZ is
1234, store (XYZ, 123) as a name-value pair in party_attr.
Have I missed something more obvious, like the correct place to record
assigned customer numbers?
Cheers, Iain
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/535 - Release Date: 15/11/2006