How to Auto Complete Fields in a Database

I have created a data entry form and split the database between front-end and back-end. I have a requirement for certain fields to auto complete. I do not want the rest of the fields auto filled, simply specific fields to auto complete. Does the split database make this impossible?

Popular White Paper On This Topic

I'm not sure what DBMS you're using, or what you meant by "split the database between front-end and back-end". But most databases allow you to define default values for columns. Those defaults could be specific values, or the current date/time, or the userid that inserted the rows. If you need something more complex, you could probably define a trigger on the table to populate the additional columns.

I am not sure of which database you are using, but in DB2 you can use
DEFAULT clause while creating the table in which you are inserting records.
So when you perform INSERT on this table (created with DEFAULT option on
one or more columns) if you specify a value for that column in INSERT
statement that value will be inserted in table and if you don't specify a
value the DEFAULT value will be used.

Also, you can use Rownumber()Over() if you want to generate a value and use
it in INSERT statement. Using triggers is also an option.

Your requirement is not detailed enough. What application are you using for your data entry? Otherwise, you can use events such as on-focuss, onclick etc.. on those particular fields that you need autocomplete

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.