I appreciate all the help with my question and have come closeto solving my problem. I have been working with the calculation that was posted on this site Max(Self::Order#)+1 This works but it does not search for the highest number in all records it searches for the highest number in the selected record and adds 1 to it. can anyone help me???

Warren

Hi Warren,

This could mean that the 'self' relation is not working. How did you define that relation?

Regards,

Ernst.

In my "Current Database" I created a self join.

My database name is "Quote Entry" My Join is as follows

Relationship Name Relationship Related File

Self join for work order number work order #=::Work order # Quote Entry

My Calculation looks like this

Max(Self Join for work order number::Work Order #) + 1

It is performed using an insert calculated result script

Any Ideas???

Hello Warren,

If I understand correctly you have your Quotes and Orders in one database.

If that's the case you should have a field which is populated with a value like '1', if the Quote has become an Order. Let's call it 'OrderFlag'

You self relation would have to have 'OrderFlag' on both sides of the relation for the Max(Self::Work Order #) function to work.

Hope this is sort of understandable... Otherwise feel free to ask again!

Regards,

Ernst.

Well it did'nt take long for this to bite me in the #*. My original plan was to have 2 databases one for quotes and one for orders. thereby fixing my numbering problem when I export or import estimates that are to be converted to orders it would create a new record. My problem with this scenario is that I only want to import the new data into the order database leaving the old data untouched, but I could not figure this out. This would be the best way for me to manage this data so if no one minds I would like to strike my 1st question from record and ask this one. How do I export and import into another filemaker database 1 record at a time leaving all other data alone?:

Warren

Hi Warren,

You could do it as follows:

Make sure you have a quote # field in your Orders database (it's nice 'n handy to know from which Quote an Order originates anyway)

When you make a new Order record fill in the originating quote# (by hand or prefarably via a a script)

Setup a relation from Orders to Quotes, with the quote # as key.

You vannow either view the original related Quote data from within your Order records, and/or setup a script that transfers this data to the corresponding fields in the Order.

Again, I hope that this helps,

Regards,

Ernst.

Ernst,

Sorry, I must be tired but I disn't catched your answer.

Warren,

What exactly is an "import" step in your mind.

Quotes and Orders could be in separate files sharing the same join file.