djmiller Posted February 17, 2005 Share Posted February 17, 2005 I have two databases related to each other by a ticket number. When I create a new job a new ticket number is generated and I enter information into the related portal. It is imperative that the information in the portal retain the order in which it was entered. I have had no problem duplicating the ticket and all the records in the portal provided I don't mind sorting the portal records on a field that messes up the original order. My dilema is duplicating the portal records and maintaing the original entry order. If I sort on the ticket # (filemaker tells me it did sort them although it didn't actually change the order) I only get a duplicate of the first record in my loop. If I sort on any other field (filemaker tells me it did sort them) I do get duplicates for each record but not in the desired order. I know that I can enter say a serial number filed and increment it by 1 on creation and sort by that, but that just makes the database that much larger. Any other ideas? Link to comment Share on other sites More sharing options...
This topic is 6611 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now