Morning folks! (cross-post to [email protected] and [email protected])
I am having trouble figuring out how to do this properly. We use XRMS for our CRM, but the only limitation it has is that XRMS does not have an easy method of writing letters to a contact that automatically fills in the contacts data (name, address, etc.) but OOo does if connected to a data source. So, I created an ODBC connection to the XRMS mySQL database on my system. OOo recognizes the connection, and allows me to log in, etc. The problem is when I go to set up the field maps in the addressing; XRMS is a relational mySQL database, and information is stored in various tables using key fields. For example, to create a full address for a contact, I need to access 3 different tables in the XRMS database: TABLE DATA IN TABLE companies company name contacts contact's salutation, first name and last name addresses contact and company addresses countries countries So I set up the connection, setup OOo to access the database. But I can only seem to pull information from one table at a time, I cannot use relational data!!! How do I get a complete address in OOo using this scenario? Sincerely, Andrew Robertson Export Manager derma eR Natural Bodycare ph. 805-582-2710 xt. 244 fx. 805-582-2730 [EMAIL PROTECTED] www.dermae.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
