Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Validation on Calculation


Kieran Jarrett
 Share

Recommended Posts

I've created a stock inventory db. For each time a product comes in it gets given a GIN number. For each GIN there is a record which has a field(quantity) saying how much came in. There is then a portal showing the different times an amount of that GIN has been issued. There is then a sum field(total used) to calculate how much has been issued and then a field (total left) to calculate how much is left. What I need to do is have a validation on the total left so that it won't let it go below 0 (ie issue more stock than is left in that GIN)

 

Is this possible and if so how? It's on filemaker 8 and on windows.

Link to comment
Share on other sites

quote the admin:

 

Clear your "cookies". They are probably corrupted. After they clear, close browser completely, open browser, login and download.

 

 

kjoe

Link to comment
Share on other sites

Tried clear cookies in Safari. Didn't work. Used firefox and worked.

 

Yes that's what I wanted. I can't believe it was so easy. Thanks for your help.

Link to comment
Share on other sites

  • 3 months later...

Just had another look at this.

 

For some reason it doesn't work for the first time a record is created in the issue table. ie. the first time some of a GIN is issued

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use