Kiwi Posted May 29, 2008 Share Posted May 29, 2008 I have an Invoice Items table that requires a Line Item field. It is a summary field that is used when the table is sorted by invoice number. Very simple - it numbers the item records from 1 to x where x is the last item within each invoice. The table also contains a calculation field that is equal to the summary field. The summary field and the calculation field work great in the data file. In the interface file - the summary field is correct - but the calculation is not!!! Here is a test db I made to duplicate this special feature. The tables need to be sorted by Invoice Number. I have found a workaround and have included that in the sample files attached. I would still like to know why is does not work! Cheers. data.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5820 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 accountSign in
Already have an account? Sign in here.
Sign In Now