Search results

I have two fields, shop # and code date. If the shop # is blank, I want the code date to calculate as it is currently doing. If there is anything in the shop #, I want a Look-Up to control the code date (looking up the value from another session). Ideas?

Thanks for the reply Dan. 1) No settings to turn off any error messages. 2) The log file shows the duplicate, but the statement being terminated is what bothers me as I'm worried that records aren't being recorded and the user is unaware of the issue. 3) I will have to do that. Thanks for...

I have a field with a pallet tag that is scanned. I have validation on this field to be unique in table, yet it does not check the SQL database to see if there is already a tag that is a duplicate of the one just scanned. Am I missing anything that needs to be added to this? I do have a live...

Never mind, I'm getting them to pull now. Not exactly sure what I did, but something is working right LOL

I've been playing around with this and I came across an issue where it wouldn't pull the offset (lookup) through a live sync, so I moved it to a manual sync and it starts to work (after a refresh of the field), but my other lookup field that worked prior to that change stopped working on me...

Hi Howard, Thanks for clarifying. Been a busy week and when I looked at it the first time I didn't notice it was only put in once. Sorry about that. I believe this will do exactly what I want to do. Just got to play around with it a bit and see if suits the powers that be. :)

This works, however, the down side is the request is that the workers don't have to put some number in cause it will just mess up the date in the long run, as many workers we are trying to limit to just scanning and submitting. In the long run we are trying to calculate an expiration date on...

I'm having a hard time trying to subtract two dates. Overall I'm trying to come up with a way to take a receiving date, find the wednesday of that week and then add 49 to it. So I need a date that shows 49 days from that Wednesday of that week (which the week is Sunday - Saturday). I've tried...