First Name / Last Name are stored in the contact table as two separate fields
These two fields are then joined in the customer table (and others) Regards Jean-Pierre _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou Director DCDM Management Services Ltd Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 eFax : (44) 7006 030 893 Web :www.dcdm-ms.com ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. On 26 May 2010 04:20, Bernd Plagge <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi > > if you want to print checks with the name showing as firstname lastname you > need to change the check printing template. > There is no need to change any tables or table rows. This won't have any > impact at all. > > Regards, > Bernd > > PS: addresses are stored in a table called 'address' > > > On Tue, 25 May 2010 11:49:00 -0600 > Walter Zamora <[email protected]> wrote: > > > Hi everyone. > > I am trying to start using the print function for checks but SL writes > > lastname firstname, I need it to write firstname lastname. In the > > tables vendor and customer, it shows lastname firstname as customer or > > vendor, but it shows firstname lastname as contact. Could someone > > please tell me where this is configured? > > > > I appreciate your help > > > > regards > > > > Walter > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkv8aUgACgkQpYU8M8PbPV5SSgCgmktS2VZcoGMBXUWJh2RS66+f > TD8AnRRUVLSju14cU/BcJgVyi4vneZim > =CI/M > -----END PGP SIGNATURE----- > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
