jdenver

Spot on Lee thanks, Im finding its works for duplicates but if I carry out the test John Mark Osborne done during the video (at 2:18 into the video) of deleting a character and adding it back, a duplicate massage still shows up even though Ive added the id ≠ id relationship. Does anyone have any ideas on why this is happening.

Not sure that would work Lee. The customers table contains fields: first name, surname, house number/name, 1st line off address, 2nd line off address, town, country and postcode. So I would need to search the whole record for a duplicate. Most fields have dropdown lists on them so the date is spelt the same ie road name etc. Unless I'm missing something.

Ive created a table for customers. Whilst entering a new customer record I was wondering how to automatic search to see if the customer exist before committing the new customers record. As it stands at the moment the new record is created at the start so I would have to delete the record if a duplicate exists. Any ideas on doing this and advice please would be appreciated.

Thanks Steve, I understand what your saying regarding invoices, but creating another table I feel would be a waste as the fields I want are in the job table. Ive worked it another way now but thanks for your advice.

I am stuck on how to move forward and feel I might be taking the wrong approach. I am creating a database for my one-man business - service engineer. I have created a customers table and a jobs table, linked the two via id and foreign_id with a one-to-many relationship and all works well, the id’s are created using the UUID method. Every time I create a new job, a new serial number is created using the auto-enter serial number in the field called ‘jod_no’ in the jobs table. This is all ok if its just one call out and the jobs fixed and dealt with on the same day. But sometimes I need to create two or more jobs (and I refer to them as ‘instances’ of the first job) ie First job would be a callout and diagnose, 2nd job would be to order parts and the 3rd job would be to fit the parts. I look at this as 1 job with 2 instances. In order to do this so far I have added to the jobs table a ‘instance’ field which I wanted to display a 1 or 2 etc. depending on the number of instances created for that particular job, and a ‘status’ field that I intended to use a check box to say when the job is closed/finished. I have created two buttons on the layout one for a ‘New job’ and one for a ‘New instance’ . What is happening is when creating a new instance, a new job number is being created (because this is the auto-entry serial number field) when really what I would like is only a job number created on a new job and then that job number copied over to the new instance when a new instance is created. Would be grateful for advice on where I am going wrong or a different approach to this. Thanks in anticipation.

Sorry for the confusion. I understand why its its not worth using the cloud now, but what are the problems with it working on a NAS drive.

Im using FM12 on a mac and FMGo on the iPad, Im the only one using the db and wondered if its posable to copy the db to iCloud or put it on my Qnap NAS drive and use the file from there so as I can access it when I'm out and about and access the same file when I'm home avoiding the need to sync. If not what is the best way to do this please. Thanks in anticipation.

Thanks guys, very helpful, Ill try these suggestions over the weekend

Ive have the following script to create an address block from the individual fields in a record. Sometimes there is not data in the 'line_address_2' and this script will produce a blank line. Can someone advise me on what to add so as the 'line_address_2' field is checked for data and if blank then don't create a blank line, whereas if it contains data the data will be added. Thanking you in anticipation. title & " " & firstname & " " & surname & ¶ & houseno_name & " " & line_address_1 & ¶ & line_address_2 & ¶ & town & ¶ & county & " " & postcode

Is it possible to store a FM file on a cloud drive so I can access it from FM12 on my iMac and FMGo on my iPhone. It is only me that will access the file at anytime on the desktop or iPhone and never on both at the same time. Thanks in anticipation for any advise.

Ive been playing around with the above script as this is something I'm trying to do. After many hours I have found out it seems to be the line "return uid of theEvent". With this line removed, FM updates. Not sure why, possibly because the 'return' ends the script, thats my guess.

Thanks for that, just needed a bit of guidance, got myself totally confused, worked though your reply and its all running ok now (I had a few wires crossed). Cheers for the quick response.

I have created a database containing 2 tables, 1 being 'customers' the other being 'work info'. The relationship is set too one to many. I have a layout displaying the customers info and have set it up so when I click on a customer it opens a new layout showing the work information related to that customer. Ive placed two buttons at the bottom of the 'work information' layout for up and down but I can't work out how to script these to step up and down the found record set being displayed. The 'customers' table contains a 'pk_customers' number field set to auto. The 'work info' contains a 'pk_job' number field set to auto and a 'fk_customer' number field, linked to the pk_customers field through the relationship. Any help will be appreciated

I created the database on the iMac sometime ago, recently I copied it to my iPhone to view in FM Go. Because a password was set up FM Go wants a password to open the db. Ive now turned off password in the original on the iMac and copied a new version to the iPhone deleting existing copies on the iPhone, for some reason FM Go is still requesting a password to open the db and I have forgotten it. Why is this and anyone know how to correct this please.

Im using FM12 and wish to export some data into iCal ver.6 which comes with Mountain Lion. Been playing around with: and managed to get it to work with a button on my layout that will run this script. Is there a way to show on the layout that the button has been clicked and also is there a way to stop multiple clicking, because every time its clicked the script runs and creates another copy in iCal. Thanks in anticipation

Thanks for that, worked it out now was using GTR/R/P instead of GTRR

Sorry, ill have a go tb_recommended is a TO of the customers table with a relationship between a recommended field in the customers table. On a layout, I see the customers details and a recommend field that shows the customer that had referred this customer. Ive turn the recommend field into a button on the layout so when clicking on this field/button the script runs to show all the "referred" customers details. hope that make sense.

So my idea won't work?, can you elaborate a little on your approach please.

I have the customers ID number stored in a variable, how do I enter this into the calculation field so the new layout displays the customers details. I've included a pdf of my script. I'm not even sure if this is the right approach to do this. Customers.pdf

Just downloaded it again and tried it in v.12 and it all works, so not sure what happened the first time. Thanks again guy's

No problem comment, I worked through Fitch's option last night and have managed to get it to work. Wasn't that difficult in the end. Learnt a lot about TO's and why they are used, so very pleased about that. Thanks guy's for you help, much appreciated.

Ahrrrrr, thats what it is then, Its because I'm using v.12. I also have v.9 but the same problem. Whats so different between v.11 and v.12, or is it the conversation thats doing it.

Well I must be missing something because the file I downloaded, 'ViewSelectedChild11', as I click in the different 'childs', they change blue to show their selected but the 'details' stay set for the first 'child' in the list. I assume the details for each 'child' should change.

Thats correct, but after the tab 'Job' is active, its not displaying the job information that was selected in the 'History of Work' tab, it still showing the last job entered. I'm not sure of the script to do this. The script I have written stores the correctly selected jobID in a variable when a job is selected in the 'History of Work' tab and then activates the 'Job' tab, that all works but I dont know how to pass that variable on to get it to update the 'Job' tab info. I thought I was nearly there with the script I had created, until Fitch kindly suggested using a global field and table occurrence, I dont mind working through that method if that is the only way, it just seemed a lot of work. I have a little understanding of scripting and FM, Im still trying to get my head around it properly.

Thanks comment, can't see how thats helped me, sorry Ive tried to work out what is happening but perhaps I'm missing something