Jump to content

Newbie alert


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

Recommended Posts

  • Newbies

I am a newbie at FM but have dealt with some hardcore relational db in the past.

So it is with some embarishment I have to ask the following.

I am correcting someone elses work at the mo, and have come up against a small wall.

The item concered is a "pre invoicing system" that is to say you do stuff in filemaker it prints an invoice, export to the accounting package where all the real work happens.

The account package will auto gen its own invoice numbers, but I need to be able to store the last used invoice number in its own table.

The idea is that the filemaker "module" querries this table for the last used number, add 1, records this against the transaction and the last used number table.

whats the best way to do this, as each time i have tried a set field/getnthrecord combo script I get either blank in the field or ?

BTW the tables are not related.

Any help would be fantasic.

Kind regards.

Mark.

Link to comment
Share on other sites

This topic is 5757 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
 Share

×
×
  • Create New...

Important Information

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