reorder on linking table??
reorder on linking table??
eyal_hb
Posts: 98Questions: 31Answers: 0
i have this situation:
i have in database table called day-trip and table called Trip
i have linking table between day-trip and trip called Trip_DayTrip, in this table i have the day-trip and trip id as primary key and another column named order.
in my client side, i have option to see all the day-trips in table or to see the day-trips of one trip.
i want to able to reorder the day-trips of one trip, but i must say that the table that show the day-trip of the trip is the same that show all the day-trips, the table just get id of trip and filtered.
can i make this work with editor?
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
I'm sure you'll appreciate that its hard for an outsider to follow, but it sounds like you want to use RowReorder on a left joined column - is that correct? Its not going to be trivial unfortunately - our pre-built libraries would work with that if the left joined table had a single key value - but you've got a compound key from your description, so our pre-built libraries won't work with this. You'd need a custom solution to write the data to the database I'm afraid.
Allan