Can anyone help me write a query?
I am trying to put the Company Name in as the last name. And maybe, if possible, move first and last name to notes in the customer database.
I need to be able to look up transactions by the company name not last names so this is my best option....unless there is another idea out there.
Thanks in advance.
I recommend using the custom text fields in the customer record for the first and last name in this case.
Using administartor, run these SQL statements:
UPDATE CUSTOMER SET CUSTOMTEXT1 = FIRSTNAME UPDATE CUSTOMER SET CUSTOMTEXT2 = LASTNAME UPDATE CUSTOMER SET LASTNAME = COMPANY
I always put company name in the lastname field also... Seems to make more sense based on the reports and sorts available in RMS. This srategy allows the Note field to still be used and you can still get the last/first on reports.
Good luck!
Have something to add? Share your thoughts — no account required.
Ask the community — no account required