Jump to content

Duplicating an Invoice Problem


This topic is 5980 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.