MartinL
-
Content Count
6 -
Joined
-
Last visited
-
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.