MartinL

Thank you for your reply. I will just have to download the files to my pc and then login to the local version using the FileMaker accounts and then upload again once I have finished. Martin

I have just started to use FileMaker Cloud and have watched the video suggested in the email from Claris but I do not seem to be able to login to hosted database file using the [Full Access] account previously setup. I have created the Groups in the FileMaker Cloud instance which match the same one orininally created in my file, ie. Administrators and General Users and have set the accounts within the file to use the matching cloud Group. However I still cannot workout how to open the hosted file using the Admin account originally setup in the file. I have tried creating a pr

Hi JMW Yes, you would need to have an instance of the related table in the schema so you could use the table instance name in the query but it does not necessarily need to actually have a relationship to the other table. I am assuming that you have already included the Equipment file as an External Data Source. If you do not want to add the Equipment file to the Exam file at all I would consider creating a Web Service somewhere that you could call from a script in the Exam file which would then retrieve the data from the Equipment file using FileMaker xDBC or the FileMaker Dat A

The client needed to run the search so that they could export the found records and use them for a mail campaign. They then run the code again to find the next batch and so on until there were none left. Although the Company Name value might be duplicated the rest of the info such as the email address is not. They were trying to not bombard their clients with numerous emails at once.

Hi, Thank you for all of the replies. I used Comment's option which worked realy well even with a dataset of over 50,000 records.

Thank you for the reply. it is up to the first 6 duplicates of each name and the order is just in the order of creation.

I have a table of data where there may be many duplicate records based on the 'Name' field, however the other fields data are different. I need to find the first 6 duplicated records based on the 'Name' field and then set a number value (incremented starting from 1 ) against them in a field used as a flag. The table may contain as many as 20,000 records with each unique 'Name' value having 0 to 50 duplicates. Does enyone have any idea how I might achieve this using a script or a custom function?

If you do not want to have a relationship between the 2 table then you might want to try using the ExecuteSQL command with a SELECT statement such as SELECT Field1, Field2,Field3 FROM Equipment WHERE EquipmentID = EXAM.EquipmentUsedID Jusr replace the fields with yours then you can parse th result to get the individual field data.