8 Replies Latest reply on Jan 4, 2010 1:01 AM by Molly

    Check Boxes



      Check Boxes


      This will sounds like a pathetic question, and I apologise. I want to use Filemaker to help me manage a dataset - to retrive some market information (the point being I'm not a database designer - I just know it has to be beter than using Excel for this)


      So - I have imported my excel data, and I have set fields for the customer number, name, DOB, postcode etc - but I need each record to have one or more purchases recorded. They are theatre ticket buyers, so one customer may have bought a ticket for 8 different performances over a year, and I'd like each performance named - and then a check box (I assume), so that of the set of 15 titles I can "check" as many as they have attended.


      I have got as far as creating a checkbox, but have no idea what "value" it requires  - basically, I don't understand and reading instructions is not helping me!


      At present the data gives me multiple lines on a spread sheet when one customer has made several purchases - each customer has a number, and then a line for each show they have seen - so when they are imported they come over as duplicates - so I was assuming I would have to clear the dups somehow, then manually check the boxes working from the excel sheets. Its under 1,000 at the moment


      Make sense to anyone - sorry...

        • 1. Re: Check Boxes
             You left out the most important thing: what purpose does your solution intend to achieve? That ultimately dictates everything else.

          I suggest you look at a similar issue here:
          • 2. Re: Check Boxes
               The ultimate use is that I want to be able to find how many / who has attended x y or z performance - I assume by searching on each check box - or if I spend hours on this subject, writing a report that tells me
            • 3. Re: Check Boxes

              The link comment provided introduces you to the construct of a join table. You have a many-to-many relationship between customers and shows. That is one customer can see many shows, and each show has many customers. To capture the intersection of a customer and show, you need a third table. This table is referred to as a join table.


              So, forget about checkboxes, and read comment's thread, as it provides a complete example of a join table. Your report will be created from the data in the join table. 

              • 4. Re: Check Boxes
                   thank you - I will read and try to follow:smileyhappy:
                • 5. Re: Check Boxes
                     Just to complicate the issue, one person could see the same show multiple times, no?
                  • 6. Re: Check Boxes
                       They could see the same show, but not the same performance (date, time). So a show has performances (this is the join) to clients.
                    • 7. Re: Check Boxes

                      I don't think that fits the original description:


                      Molly wrote:
                      one customer may have bought a ticket for 8 different performances over a year

                      Anyway, I don't see why a customer couldn't buy more than one ticket to the same performance and "see it multiple times" - provided they brought extra pairs of eyes…

                      • 8. Re: Check Boxes
                           Thanks for all your thoughts, I've come to the conclusion that I need to pay someone to look at the data and set something up for me, and show me the basics -I don't have time to sort this now - I'll look for a Filemaker developer locally I think - unless that is an online service that someone offers - thanks again, and you are right, the permutations of the data could be endless, but I have a specific set of finds I need to do... and now I need to get on with some work!