An hour or so this afternoon of trialling P10.1.2. (Currently I use Filemaker Pro 15 but only as a flat file database. In FM I have in one database circa 82,000 records, dozens of fields and an extensive use of repeating fields. I’ve been using FM since FM12 but think it might be time for a change.
I have skim-viewed some videos and tried searching in Help but I’m not familiar with P’s terminology so i do not know what to search for.
In FM, I have several ‘value lists’ containing fixed data, for example (I’m in UK), counties, such as Kent, Suffolk, Norfolk, Devon, and so on. In P10 I thought I’d worked out how to set up a field where I could choose data from a preset list. In Field Properties, select Choices then type in the name of each county press enter for the next line and so on; also I select Clairvoyance and Editable. Then click Automatic Choice List.
I have named a column County. When I tried to add data, up popped a box with the names of the counties and a checkbox. I clicked the check box and the field was populated. The first time I did all that I experimented adding a few counties in Choices but having found it worked i added lots more. But the checkbox doesn’t display all the counties. I’ve dragged the box to lengthen it but doesn’t make any difference.
I daresay what I should be doing is simple but only if you know what are doing. What should I do? tia.