Dear all,
I've been working with (what I hope is) a normalized database I've created to help me organize a conference, and in which I've had to establish many-to-many relationships through junction tables. For example, one abstract may have multiple authors, and an author may have submitted multiple abstracts.
Everything is going great - there's just one little thing that's been bugging me. When I create the report showing the abstracts and their respective authors, it's really important that the names of the authors appear in exact order they were added in my continuous sub form - not by ID, as it's currently the case.
For example, right now, my form shows:
Main form: Abstract 131
Sub form: Marie C., Dylan G.
Which is the order I'd like to keep in my report (not Dylan G. (ID 146), Marie C. (ID 160)).
Can you help me? Thank you in advance.
I've been working with (what I hope is) a normalized database I've created to help me organize a conference, and in which I've had to establish many-to-many relationships through junction tables. For example, one abstract may have multiple authors, and an author may have submitted multiple abstracts.
Everything is going great - there's just one little thing that's been bugging me. When I create the report showing the abstracts and their respective authors, it's really important that the names of the authors appear in exact order they were added in my continuous sub form - not by ID, as it's currently the case.
For example, right now, my form shows:
Main form: Abstract 131
Sub form: Marie C., Dylan G.
Which is the order I'd like to keep in my report (not Dylan G. (ID 146), Marie C. (ID 160)).
Can you help me? Thank you in advance.