1 Reply Latest reply on Sep 12, 2011 1:18 PM by philmodjunk

    how to create a custom data entry screen

    XP

      Summary

      how to create a custom data entry screen

      Product

      FileMaker Pro

      Version

      11

      Operating system version

      mac os

      Description of the issue

      we are developing a Point of Sales system for retailers, we need to create a sales screen where we can key in VIP code and merchandize code (barcode), how can we create such screen? in the database, we have VIP master table and merchandize master table, once we get the input of the two code, we do validation against the information in the two tables respectively.

        • 1. Re: how to create a custom data entry screen
          philmodjunk

          This portion of the forum is intended for reporting the discovery of possible software bugs. Questions on how to use FileMaker Pro should be posted to the FM Pro Forum. (And had you done so, I would have seen and responded to your question hours sooner....)

          There are a lot of unaswered questions about what you need to do here.

          First, a POS system usually has many more tables with relationships similar to this:

          Clients----<Invoices-----<LineItems>-----Products

          Each record in Clients records data on a given client (many POS systems do not have this table). each Record in Inovices is a specific Sales Transaction. LineItems lists the individual items purchased and their quantities on a given invoice and also links to Products for pricing, description type data.

          Do you have this kind of system set up?

          Does a "VIP code" idenfity a specific client or just a specific discount?

          The only real difference this makes is in what table you'd store the barcodes and any relevant information about each such code.

          There are a number of threads that discuss how to set up a barcode, magnetic strip or smartcard scanner to work with FileMaker. As long as your scanner can operate in "keyboard emulation mode" (almost all can), you can use the "search the forum" box at the top of this screen to look for posts about "barcode scanner" to pull up a number of threads that discuss how to design layouts and scripts to support barcode scanning.