Help with the custom Function

[Lola]

Hello All,

Please find attached two sample files that Im working. In Materials_DB1 when I create a new record my lot numbers are repeated, while in Materials_DB2 it works fine. is there something wrong with my other file?

the monthly serial that Im using is from Daniel (Raybaudi )

Materials_DB1 Username is Admin PW: No Password

 

Thank you so much in advance

 

 

 

Materials_DB1.fmp12

Materials_DB_2.fmp12

Edited August 20, 2017 by Lola

[Lee Smith]

Material 1 is using or relying on a related table for the number (table not included)

Whereas, Material 2 is not using a related table.

[Lola]

Hi Lee,

Thanks for the reply, How can I solve the problem?

 

Thank you

 

Edited August 20, 2017 by Lola

[Lee Smith]

I can't find  the Custom Function by raybaudi that your using. 

Check out the relationships, you are trying to use data from a non -  existing table and relationship.

 

[Lola]

Hi Lee, 

I already deleted all the tables that is connected to my material table, but still giving me same result.

The custom function that Im using is on my inbox.

Edited August 19, 2017 by Lola

[Lee Smith]

This is part of the problem.

I saw the Custom Function you have before I asked the question. I wanted to see the source of this CF,  to  see if I could pick what you're missing..

I have several of Raybaundi's calculations and custom functions, but I don't have this one.

Lee

[comment]

14 hours ago, Lola said:

In Materials_DB1 when I create a new record my lot numbers are repeated, while in Materials_DB2 it works fine. is there something wrong with my other file?

Yes, it's corrupted. Throw it away and go back to the last good backup.