Hello everybody! I have what I think is a very basic question.

1). The database is to organise my contacts by what "status" they are.

2). It has one table. There is a field called STATUS, which can have one of three values: COLD, WARM, or DEAD.

3). I want to see a screen that looks like this:

==

COLD

John Doe

Jane Smith

WARM

Bill Bloggs

==

In SQL terms, I'd run two queries (GET_COLD, which would find all records where the status = COLD, and GET_WARM). Then I'd display the output of each one alternately.

But I have absolutely no idea how to achieve this in FM. I'm sure it's basic: can anybody help? Sorry if this is a stupid question.

Thanks for reading,

Chris.

In FM you cannot achieve the above without doing a subsummary report by Status.

In a list view, it would show, when sorted by status:

John Doe COLD

Jane Smith COLD

Bill Bloggs WARM