Jump to content
Sign in to follow this  
Lola

Help with the custom Function

Recommended Posts

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

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

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

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

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

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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