Hello.

I have a table named "Jobs". 2 of the fields in this table are named "Rough deadline" and "final deadline".

What I would like to do is to display a list in the form of a job schedule alng the lines of:

Job 1: Rough deadline: (date)

Job 2: Rough deadline: (date)

Job 2: Final deadline: (date)

Job 1: Final deadline: (date)

...and so on. So the list is sorted by the date, rather than the job number.

Is this even possible?

There is a sort option under the Records section of the menu, if you want to manually sort it. Otherwise, add a sort script step to the script that goes to your list layout. So when you press the button to go to that layout, it will always sort it.

Thanks. Unfortunately, that's not the problem.

The problem is combining the two separate date fields into a single list.

You cannot have a single record showing up in two rows. You COULD put the dates in another table, so each job would have two related records.

Yes, that could work I guess. I'll give it try.

Thanks