The database also includes all the usual calculated physicochemical information (shown below) so the results of searches can be filtered to remove any high logD or MWt compounds. They also wanted a checkbox next to each optional item, so that the proposal. The fact they are all from different clusters gives additional avenues to explore. So I have to put the MLB after each Checkbox value.
The Work-Around: Normally this wouldn't be a problem except I'm importing Checkbox values from a spreadsheet.
#Checkboxes in filemaker pro 6 manual
The first thing to note is that these structures come from a range of different clusters as determined by the other clustering techniques, they are made up of compounds from both publications, and they offer some initial ideas SAR to explore. Filemaker Pro when it exports checkbox values it places a Manual Line Break (MLB) (you get it by using Shift-Return (or in MS Word) This is not really a problem or a bug in FMPRO. I’ve selected (by clicking the checkbox) a handful of structures. Clicking on the “MaccsCLUSTER” button finds all the compounds in that cluster as shown below and you get similar results for the 3PP_CLUSTER button.Ĭlicking on the “mcs_cluster” finds over 1800 compounds and browsing through there are some interesting structures. The remaining three clustering options use all records. These first two clustering results were kindly provided by the Glaxo group and thus only cover a sub-set of the records. This shows structures with similar polycyclic ring systems. Next we have the structure, biological data and then clustering results.Ĭlicking on the question mark (if present) highlighted by the red box opens another window giving details of the literature information and a link to Pubmed.Ĭlicking on the “Chemical cluster Nr” button finds all the compounds in that cluster as shown below.Ĭlicking on the “GraphFrameCluster” button finds all the compounds in that cluster as shown below. The checkbox highlighted in purple allows you to mark interesting records, clicking the “Get” button displays only those records that you have checked. The first section contains compound ID, suppliers and literature references and a link to eMolecules. The image below shows the details for a single record, moving from left to right. If anyone would like a copy please email. Ive read from FileMaker Pro 10, but couldnt find specifics on filling and deleting check boxes in multiple records, especially if limited to.
#Checkboxes in filemaker pro 6 download
I’ve created a FileMaker Pro database that you can download that lets you explore the information. Whilst the MOE database is excellent for keeping track of the chemical information it is perhaps not ideal for cataloging and exploring the associated information that is provided in the multiple spreadsheets available in the supplementary information.