Having human friendly identifiers is fine but use autonumbers as the primary key and foreign key. To do this go to File, Options, Current Database, ensure the Compact on Close option is selected, and then save your database.ĭistinguished Expert This award recognizes someone who has achieved high tech and professional accomplishments as an expert in a specific topic. Since you want to reset the barcode each day I assume you intend to clear the tables after you are done using the database. Save the query and then open it When you open the query all records in your table will have a barcode in the format you specified. Select the table that needs a Barcode field added 3. Commented: I suggest 2 different fields in the table plus a static HCPV-R which could be stored in a global constant instead of a table, a date formatted as required, and a number formatted I suggest the following: 1. Last Modified: I would like to create a custom Serial number for a few Tables I have. We help IT Professionals succeed at work. IT issues often require a personalized solution.
Need support for your remote team? Check out our new promo! Select all Open in new window.
