Jump to content
Lola

Help with the custom Function

Recommended Posts

Lola    2
Posted (edited)

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 by Lola

Share this post


Link to post
Share on other sites
Lee Smith    147

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.

Share this post


Link to post
Share on other sites
Lola    2
Posted (edited)

Hi Lee,

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

 

Thank you

 

Edited by Lola

Share this post


Link to post
Share on other sites
Lee Smith    147

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.

 

Share this post


Link to post
Share on other sites
Lola    2
Posted (edited)

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 by Lola

Share this post


Link to post
Share on other sites
Lee Smith    147

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

Rel Screen Shot.png

Share this post


Link to post
Share on other sites
comment    1,392
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.

Share this post


Link to post
Share on other sites

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


×

Important Information

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