Display records with distinct fields only

[Liquid]

Hi guys, I have a portal that is supposed to display surveys that a Contact (individual) has taken. I dont track individual surveys the users have taken instead I track the answers for the questions on the surveys. The User Answers table has a questionId, an answerId, a surveyId, a contactId, and a date taken field. Now what i want to display in the portal are records with distinct surveyId and date taken pairs. In SQL this is easily accomplished, but I am having trouble getting it done in FileMaker. Thanks in advance for the help.

[RalphL]

I am having trouble understanding exactly what you want when you say records with distinct surveyId and date taken pairs. Does this mean that you want to show all surveys with that id and date?

[Liquid]

Yes that is exactly what im saying. The problem is in my User Answer table that pair will be repeated with each answer the user has for the particular survey. Here is an example of entries in the User Answer table

SurveyID DateTaken QuestionID AnswerID

1------7/22/04------1---------2

1------7/22/04------2---------6

1------7/22/04------3--------12

2------7/22/04------9--------33

2------7/22/04------10-------36

Now what I want to see in my portal for this table is one entry for SurveyID 1 with DateTaken 7/22/04 and one entry for SurveyID 2 with DateTaken 7/22/04. I hope this clears things up

[RalphL]

Add a calculated text field to the User Answer Table = SurveyID & " " & Date Taken.

In you main table add a valule list based on the calculataed field. Add a new calculated text field = ValueListItems (File Name, Value list) This will replace the portal.