Newbies JJAW Posted November 13, 2007 Newbies Share Posted November 13, 2007 We currently use Filemaker 8.5. We have a number of repeat customers. Instead of creating a new invoice I often duplicate a previous invoice. The problem I have is our costs on items change. Right know when I duplicate a record it duplicates with the cost of the old record and doesn't update the record with our current costs. I have to re-enter the item number of the item to get the current cost to show. Any quick fix to this? Link to comment Share on other sites More sharing options...
Fenton Posted November 13, 2007 Share Posted November 13, 2007 I don't really see how you'd have 1 product per Invoice, as you imply. Perhaps so. If so, just Set Field [ product ID, product ID ], then Exit Record, to bring in the current cost. Which is the same as what you're doing manually. Link to comment Share on other sites More sharing options...
Newbies JJAW Posted November 13, 2007 Author Newbies Share Posted November 13, 2007 We have a total of 8 lines of products we can enter. The product costs are not updating to our current cost on any of the lines. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted November 13, 2007 Share Posted November 13, 2007 How come the newly created invoice isn't the opposite of orphaned ... deprived, childrecords shouldn't exist at all since the autoenter in the parentID would lack matching. How come only 8 lines exists, where the products are entered. You're giving yourself away here, shouldn't it be repeating fields you are using here?? Invoicing from fm3 and upwards should instead go by this principle: http://www.filemakerpros.com/joinprint.sit Duplicating a structure as this would require, some scripting in both the tables involved, alternatively could Applescripting deal with both tables in one single command! --sd Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5980 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