
FileMakerHarry
Members-
Content Count
36 -
Joined
-
Last visited
Community Reputation
0 NeutralAbout FileMakerHarry
-
Rank
member
-
Deleting records from a found set
FileMakerHarry replied to FileMakerHarry's topic in Finding & Searching
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 -
Deleting records from a found set
FileMakerHarry replied to FileMakerHarry's topic in Finding & Searching
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
-
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
-
Importing Data and Deleting Duplicates
FileMakerHarry replied to FileMakerHarry's topic in Finding & Searching
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!
-
Importing Data and Deleting Duplicates
FileMakerHarry replied to FileMakerHarry's topic in Finding & Searching
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