Without Loop Script, can I create new table with records that are grouped by particular fields?

[mak]

Obviously, it is possible to export records that are grouped by particular fields.

But I have to import that exported records to create new table.

So it means if I'm making  it automated by the script, I'll need to do something like this below within script

 

Assuming there are 1000 records here, and there are 3 fields such as FirstName, Gender, and State

So something like this => Mike, Male, CA

 

1. sort by Gender field and State field for grouping

 

2. set a variable for export destination path.

 

3. export records (gropued byGender field and State field) to the variable above. Assuming it became 200 records for total after grouping  as result.

 

4. import the variable(exported records) to particular field.

 

Yes, I want grouped records within the same filemaker solution as new table.

 

Can I make this more sophisticated?

If I use MS Access, I can obtain grouped records within 10 seconds within a solution.

 

 

[comment]

I believe this is a duplication of your other thread:

http://fmforums.com/forum/topic/92455-what-is-ordinary-way-to-do-grouping-records

[Wim Decorte]

 

 

Yes, I want grouped records within the same filemaker solution as new table.

 

 

Why?

Given that in FM all interaction with data in a table is through a layout based on a TO... this would not really get you anywhere useful.

And you'd now have duplicate data.

 

What purpose would this new table serve?  Perhaps there is a way that gives you the functionality that you are after without duplicating data.

[Lee Smith]

Please do not double post. If you have additional information to provide, then just reply to the original topic.