Jump to content

split records


This topic is 2586 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

hi everyone. i'm new at this forum and i'm beginner user of fm. i'm not sure about this is the right topic for that , if it's not sorry about that.


as you see i have file including 1656 record. i have to split that records as  0 to 1243 and  1243 to 1656.

i can't find way to this. could you help please?


thank you already.


Link to comment
Share on other sites

Hi Demerol and Welcome to the FM Forums,


Why do you feel your file is damaged? Please explain what you mean.


What you are asking does not sound like corruption. 


I see this is your first post, and that you are a new user. 


As a new user of FileMaker, it is normal to have a lot of questions.


What do you mean by splitting the records into two groups? Do you know how to perform a Find?



Link to comment
Share on other sites

  • Newbies

hi lee , 


i guess i couldn't explain my problem. i haven't got corruption or damaged file problem. 

i have database of something and it has 1656 records. i have to split that records as 0-1243  and 1243-1656. 

so it should be  2 database . did you understand? it's simple. I'm struggle for two days for it but i can't do that.

Link to comment
Share on other sites

I fail to understand why you would want to split these off as two databases when you can do a find or find/omit on your current database. Unless I'm missing something what you want is a really bad idea. Perhaps explain why you think you need to do this?

Link to comment
Share on other sites

  • Newbies

it's complicated. there is a database of our archaeological excavation. i enter 1243 records of these, after that i enter 423 records again. and my professor said you should separate new records. now i have 1656 records and i want to split this new and old records as 2 file. that's nonsense but i have to do that. that should be easy but i couldn't. please help me or i have to do manually.


Link to comment
Share on other sites

that's nonsense but i have to do that


It probably is - so think twice before you do it. I am not sure what your data is, but if those two groups of records have the same characteristics (i.e. they both fit your table's fields), then you should keep them together - and possibly add another field to distinguish them



Otherwise this should be easy: show all records, unsort, go to record #1 and omit multiple (1243?) records. Now you should have a found set of 423(?) records, that you can export to a new file. Next, show omitted only and export again.


These numbers are iffy, because 1243 + 423 = 1666, not 1656.

Link to comment
Share on other sites

Your professor is simply not correct. Records are each separate entities. Groups of records can be separated by doing a find. Better to have a script that executes on first window open when your professor opens the file so he/she sees the proper found set. Sometimes certain people who understand little about database technology ask for things that are simply unnecessary or downright silly.

Link to comment
Share on other sites

Since you stated


hi lee , 


i guess i couldn't explain my problem. i haven't got corruption or damaged file problem.

I moved this From "Damaged / Corrupt File Problems" to "Relationships.because it seems this would be a better fit.


If this file is not intended to grow beyond what you have presented, then the finds presented above should do what you are needing.


However, I get the feeling that this is the first step to a much bigger need.


If Im correct, then you need to look into making an ERD (Entity Relationship Design) of your file. There are some training sites that provide information on how to do this. If you want my recommendations, contact me by private message.



Edited by Lee Smith
modified the auto
Link to comment
Share on other sites

This topic is 2586 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Quito
      I want to create a Dropdown List of numeric options to select a range of records.  For example, the Dropdown list would contain:
      Each option would select the next 5;10;20;50 or 100 records to the right.  A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records.  The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is.
      Any help will be gratefully acknowledged.
    • By Mel617
      I am new to filemaker and am using Filemaker 14 with starting point.  I am connected remotely to my network.
      I am in the account section of starting point and for some reason when I click the create new record button it is randomly adding data from another record in the database and linking a contact to it. Specifially in the Tabs at the bottom "contacts" "projects"
      Does anyone know how to change this and make the new record completely blank?  
    • By Rook183
      I am sure this is one of those simple ones… that has me bamboozled for nearly 2 days now.
      I need to limit access of my users viewing only a limited set of "Company" records after they log in. The companies that they are allowed to see are listed in each respective user's profile.
      My opening script goes to the user's profile and creates a global variable for each company that they are allowed to view.
      When I go to the "Manage Security > Edit Privilege Sets > Records > Custom Privileges > Limited > Script", and use any of those variables (e.g. $$Company01"), the records table returns no records at all (i.e. as if there were no matches). When I test the script and use text for any one (or several) of those companies by name (e.g. "ACME PTY LTD"), the access rules work perfectly.
      To be clear: The global variables themselves are correct. I know this this because they work in other scripts absolutely perfectly, so the variables DO match the names in the field.
      The script looks like this:
      $$Company = Table Manufacturer or 
      $$Company01 = Table Manufacturer or
      $$Company02 = Table Manufacturer or 
      $$Company03 = Table Manufacturer or 
      $$Company04 = Table Manufacturer or 
      $$Company05 = Table Manufacturer
      In every respect, the variable matches the actual text, but I can only imaging that there is a problem with my syntax?
      Please advise.
      Many thanks
    • By Pyorkie
      Anyone have an idea on how to display the Record number in a field?
      I want the field to display the record number every time I got to the "Next or Previous" (scroll through) record.
      Thanks in advance for any help.
    • By lee2121
      I have two identical tables only one of them has data inputted into it the other table has no user access.
      After a user has created a new record in Table A i want all of the data to be duplicated into Table B and just stored there. This is because Table A can later have individual records deleted and we need to keep a backup of all the data entered into Table A
      I did write and export script which exported the record from Table A to excel and then imported the excel file into Table B but this does not work very well over our network.
      Any suggestions would be appreciated.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.