FileMakerHarry

Right, so to recap: I have a Table, 'Products' with a field 'Job Number' and 'Product ID'. Product ID is unique. Each Product ID is an individual number. I have another table, called 'Errors'. This only has one field, 'Product ID' and is also unique. I have linked Errors::ProductID = Products::ProductID

WOW! Thank you, thank you!

OK, thanks. I do not currently have a relationship between the two, so i'll put that in. While I'm omitting the records from the 'found set' i need to delete them from the entire database. Does this script you've written show me the 65? Can it show me the 247 so i can 'Delete Found Set'?

Hi Board! I have two tables, one that I have produced a found set from, which has 312 records. This is 'Table 1' I have another table ('Table 2') that just contains one field, which is also a field in Table 1. It has 65 records. I want to delete, from Table 1, any record that ISN'T in Table 2. That would leave me with 65 records in Table 1, having deleted 247. What's the process? I've got as far as having the 312 in a found set, and a table with 65 records, some of which match those in 312, but no relationships or anything like that. Thanks for your he

Hello Board, Again, thank you for all your help recently. I've learned a lot about Looping, Counting and Variables and have really put them to work several times over. We use a database here with a field that contains a barcode number. It's 10 digits long. Last night, i changed the field over from 'Number' to 'Text'; because we're about to start scanning alphanumeric codes into that field. It went OK and you can now input those alphanumeric codes into the field. However, when i use our barcode reader to scan into that field, it puts a carriage return at the end of the numb

Hi! I've managed to get this whole thing working with all your help. Thank you very much. Harry

I sort of understand this, but looking at this: Loop Set Variable [ $count ; $count + 1 ] Exit Loop If [ $count >= gInput ] Duplicate Record End Loop I see that the first time it runs through the loop, it's adding 1 to 0, isn't it? To make the first 'count' a 1. So, this script is resetting the Variable $Count every time it runs through the script? Do i have that right? Cheers.

I think i understand this a bit more. I think i confused Count with $count. Loop Set Variable [ $count ; $count + 1 ] Exit Loop If [ $count >= gInput ] Duplicate Record End Loop //So, you're setting a Variable called $count as + 1 and the way it works is that it 'just works'. That part of the script just becomes a little counter for the loop script and is then referenced to the global variable that was set from the global field that was entered into the dialog box!? I think i have it.... I'm going to bed, but i'll try this tomorrow morning. Thank you!

Hi, thanks. OK, i appreciate what you're saying. Its a bit difficult for me to talk to you about it because my understanding of it is quite low. Well, our JobNumbers are 5 digits long. So what i'd like is when 5 digits have been entered, it automatically goes to the next correct field. Right now, though, that's not required and there is a step of user interaction to move to the right field. I have set the script to run OnFieldExit. And that part works. Let me explain a bit more about the 'ID Grabbing'. We have a pool of labels with sequential numbers on them. They are delivered from

Forgive me, but I don't understand how to make this script run. What is the trigger for it? When a number is inputted into the JobNumber field? Or when you exit out of it? Thanks, Harry

OK, well, i haven't used Server so don't know the difference really. I suppose my questions was about whether Scheduled Time services were only available on Server, as opposed to the 'Client' version. Like the restriction on concurrent connections with Client 'vs' Server.

Thank you LaRetta. That will take me a bit to go through and fully understand, but I will come back and let you know how I get on. Thank you again, it's really appreciated. I have spent a long time looking through all my FM books, but it's hard to know which tool to pick up to do a job when you're not sure how many tools are available and what they all do. Learning curves! I will also try and detail the bit you didn't get. My explanation was vague because it is a bit different but also unimportant to my query. Cheers!

That's really concise and has answered my questions, thank you so much! It's really clear to me how it works, so I'll start by implementing that. Thank you again, Comment.

That's great, thank you. I haven't tried it yet, but i can see how it works and it's not very complicated so cheers. Will Filemaker Server do this sort of thing without iCal being involved?

Hello Board, Thank you for all your help so far. Even if you've not replied to one of my recent threads, i've read a lot of the posts here and gained some good understanding of what I'm doing. More importantly, i've built parts of a database that are working and helping people do their jobs. I still need some help. I need to build a script that will automatically create new records in a database. So, an operator inputs a JobNumber. This looks up data from the ProductTable. If the Product listed on the JobNumber has a field value (in a paticular field) of YES, then i need th