Latest News

Hey, I have 4 tables, Contacts, Products, Lineitem, Orders. 

I have a relationship that looks like this "contacts-order-lineitem-products".. so I can see the products ordered by the contacts. But I also want to see How many of the products they have ordered. Like a summary that shows how many of the products they have bought, So when I open a customer post I want to see what product they order the most. And then sort the portal by that field, So the first post in the portal shows what they have bought the most.

I would really appreciate help!

Hi All,

I'm new to FM Forums so I hope i'm following all the correct rules and procedures of the site.

My Question: -

I'm an experienced Microsoft Access User and on a form you can add a 'Combo Box' or 'List Box' that will list all the records for that single form and when one is selected will take you straight to that record. I suppose in a way it's acting like a filter without the need to scroll through all the records on the form individually.

I've recently just purchased Filemaker 12 as required to develop a database for web use and trying to do a similar thing with a 'drop down list' on a layout.  i.e My table is called 'Primary Schools Directory', a layout has been created for this table and i have placed a 'drop down list' on the layout that lists all the records in the table/layout. I just want now to be able to select one of those records and it takes me straight to the record on the layout.  I don't want to do it via a portal, I understand how these work.

I have purchased the books 'FileMaker 12 Developer Reference' & 'FileMaker Pro 12 The Missing Manual' and so whilst I have a feeling it has somethig to do with 'Script Triggers' and 'Goto Record', after lots of reading and trying various scripts I just can't figure it out.

Please can anybody help?

Kind Regards

Steve 

I am trying to apply padding to a checkbox field so the slightly rounded border isn't touching the checkbox elements.

I used FMP 12 Format/Layout/Line Spacing and put in 10 points on the left, to see if I could notice some padding effect. No luck. Am I missing something obvious?

I have a screenshot of my checkbox with the 10 points left setting and showing the settings as well.

Thanks, David