AnsweredAssumed Answered

How to Combine multiple records into 1???

Question asked by mkiv on Feb 17, 2010
Latest reply on Mar 5, 2018 by washutech


How to Combine multiple records into 1???


 Hi all.  I'm trying to figure out a solution to the following task.  I've got a table with fields similar to the following:






Right now to data that's imported is in the following format (6 records).

A - Math -3

A - English -4

A - Science -3

B - Math -2

B - English -3

B - Science -3


What I'm trying to accomplish is to get the data into the following format (2 records):

Student      Math   English    Science

A               3           4           3

B               2           3           3


 I've thought about using Cross-tabs but would appreciate other sugguestions/solutions.



Thanks in Advance







In order for other forum participants to better help you, please provide the following information when posting:

1. The version of FileMaker Pro you are using: FMP10
2. The operating system and version you are using: Windows XP

3. Describe as much detail about your database as is pertinent to your question.  Otherwise, other forum participants will have to guess and/or ask for more information.
5. Try to indicate your level of experience with FileMaker and/or other database designs.  If the person responding to your post knows that you are a newer user, they can give a more detailed step by step description:Moderate