2 fields into 1 list

[Cap'n Splatter]

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?

[mr_vodka]

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.

[Cap'n Splatter]

Thanks. Unfortunately, that's not the problem.

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

[comment]

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.

[Cap'n Splatter]

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

Thanks