I'm attempting to order items in Table 1 based on a foreign key in Table 2, which is a field selected in the items in Table 1.

The items appear to move around fine, and the database is being updated with new ordering, but refreshing the page in the backend is reordering the items again without the user moving them around. I'm not sure, but it seems like it's automatically reordering the database on page refresh based on some other sort of sorting, but I'm not sure why.

Any ideas if this is a bug? I'm fairly sure this is set up correctly in my project.

- Andrew

Did you setted this FK as group in the ordering wizard ?

Because this could be your problem.
When you define a group, it separate the items in differents ordering groups.

Are the items correctly ordered within the same FK value ?
Can you provide the PTL ? (Project Table Layout), so I can check manually ...