Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
So you have to think about using a primary key in a database? Quick books would therefore benefit greatly from hiring ONE database administrator for your global team. Primary Keys are as basic as wheels on a car in a database.
Or.... is it that Primary keys are hidden from customers, and yet actually present for all customer data entries, for ease of searches and debugging from QuickBooks perspective. Benefitting you, and not us.
I don't mean to be cheeky, it's not my preference. But it is a significant blunder to use anything else as a primary key, other than a correct primary key sequencing convention.
I don't want to print invoices and have a customers primary key visible on their invoice, advertising that we are using QuickBooks Online, as we have to stuff the primary key into another field and concatenate this data it into the business name data. And no... notes is not a field one can use to import.
Just do things properly? Hire a database admin? makes sense right?