Simon UK

Hi, Probably a junior error so apologies in advance but I cannot get my clients DB to connect to their Office 365 SMTP relay. Hostname: smtp.office365.com:587 StartTLS=1 Username = username Password = password Username and password are those for the login to Outlook Office 365, I assumed these would be correct? But I'm getting "authentication failed, please check authentication info" Log attached, any ideas???? Best regards and thank you, Simon 360Plugins_FMAdvanced.log UPDATE: This has now been resolved however I'm getting an error 'Exception Reading Response' ...

Hi, That's been really helpful in clarifying my thinking, thank you both. Simon

Hi ggt667, That has got me thinking! I've set the 'Company' table as the main focus and have related tables for Contacts, Addresses etc with the ability for the user to choose the main Contact, main Address etc. Whilst the client is talking to a Contact the main focus is doing business with the Company as contacts come and go. I thought that it would be better to associate all work done, jobs, invoices etc with the Company primarily rather than the Contact? Do you believe I should re-think this? Simon

Hi, I'm developing for a service company that has a telesales and a field sales team. They then have a service team that visits customers and services products on site. Question: Both prospects and customers are currently in a table called 'companies' and have a simple flag (dropdown list) to indicate the difference. Challenge is that the table has grown to 124 fields with some of the fields only relevant to either Prospects or Customers. Remarkably I have never needed to create 1:1 relationships in such a scenario but I'm thinking of doing so. Would it be advisable? I'm thinking specifically it may lead to performance improvements on list layouts with some 20,000 prospect records being loaded? Also having not used this technique before is there a way of having the related 1:1 records in the separated tables auto create when I create a record in the main company table? I'm thinking this might be a really stupid question but I'm quite tired and just can't see it? I look forward to your opinions. Thank you, Simon

Hi, I have (at the moment) a very straightforward database. Two tables, with one table containing data for 'Time' worked on various jobs by employees. Also in this table is 'Department', 'Client Name' etc. The other table is 'Jobs'. I have created a third table called 'System' which has a single record with an ID of '1' which links to a Foreign Key in the Time TO which in turn links via a Foreign Key of 'Job Number' to the Job TO ... System>Time>Jobs. I have a layout based upon 'System' which has a portal on it that is linked to the Job TO. I then added global fields to the 'System' table and created multiple relationships between 'System' and 'Time' using equijoins and as I select combinations of 'Client Name' and 'Department' the portal is filtered. However, as I am using Equijoins I cannot leave any of the globals empty and just filter for Time based upon a 'Department'. So what I need is a multiple relationship that allows for any and all of the globals to be populated and return relevant result in the portal. And that's where my Filemaker experience just about dries up!! Any pointers would be gratefully received. Thanks in advance. Simon

Hi, I'm importing a worked hours dataset from Excel every 30 minutes and need to find new Employee and Job records within the dataset. The Employees and Jobs also have unique ID's which I suppose should make it easier. I thought I could somehow compare the newly uploaded data to the Employee table using the unique ID and find those records in the new data that don't have a corresponding record in the Employee table? I thought this would be easy ... I tried a 'not equal' join between the ID field in the Employee table and new data Employee ID field and expected a list of data for Employees not in Employee table? Any thoughts? I'd be very grateful? Thanks in advance, Simon

Hi, I'm looking to calculate the min value from 4 fields in a record but want to exclude zero values except where the fields are all zero values. I'm very confused and would appreciate any pointers on this. Best regards, Simon

You're very kind, thank you. I can now at last get some sleep, it's just coming up to 1am.

LaRetta, Found solution and now I feel very very stupid ! I don;t know how but some mysterious tab control found it's way onto my layout. I decided to 'select all' to make nothing was obscuring the portal and there it was, with tabs set to 0 pixels otherwise I could have spotted it. Really sorry to waste your time on this but I appreciate your efforts to help me solve this. A junior mistake I hopefully won't make again. Best regards, Simon

Hi LaRetta, It's only specific fields that are not showing. I've tried recreating the portal but it doesn't help. How do I add a screen shot here? Simon OK worked it out here is the screen shot ... Any ideas would be gratefully received!

Hi, I have a script that creates a master job and then in a related table creates 'sub jobs'. I have a table layout that shows all the records are in the sub job table with correct foreign keys for the master job table. The relationships are stated correctly and I have allowed the creation of records in the 'edit relationship' dialog. However when I view the portal in the master job layout I can see the multiple rows for the sub jobs but some of the data is not showing in the portal??? I've checked the height of the fields to ensure they are not outside of the portal, but can't think what else could be the problem. This is turning into a serious pain in the *&^* and it's kept me busy for a couple of hours now. Any ideas ... probably something simple but I can't see it!! Help ....

Again and again you provide spot on solutions .... many thanks. I spent a while looking for the same problem ... came here and you did it again. So grateful. Simon

Brilliant ... was able to simplify my scripting and use Pause/Resume Get(ScriptResult) to create a far better solution. Thanks again ... Simon

Hi, I have an add new record button on my database which 'forces' users to select a 'Client' and 'Client Contact' before creating a new record to ensure . The problem is that I have several scripts for this process and am convinced this cannot be the most efficient method. Script 1 opens the client window Script 2 is triggered when the user selects the client. It stores the pk_ClientID as a $$variable and then closes the 'Select Client' window and opens the 'Select Contact' window which is filtered based upon the pk_clientID which was selected in the previous step. Script 3 is triggered when the user selects the contact. It stores the pk_ContactID as $$variable and closes the 'Select Contact' window, creates the new record and 'SetField' for both the pk_ClientID and pk_ContactID and then asks using a Custom Dialog for a job description before entering this to the record also. Any ideas on making this more efficient. I have heard of pausing scripts for doing this kind of routine but not sure whether it is relevant for this? Regards, Simon

Hi, Thank you so much for the advice. I'll put this to work very shortly. Looking forward to the day I can help others too. In the meantime thanks again, it's really solved a headache. Kind regards, Simon

Hi, I have a table where I store some default values such as charge rates and want to 'LookUp' these values when creating new job records in a job table. I created them as global fields and intially these seemed OK but when I reoponed the database and created new jobs the 'default charge rate' was empty? Has anybody else had this issue? I'm obviously doing something wrong but can think what else to do. I have the same problem when wanting to store an image for an invoice header in the same table as a container? Any advice would be appreciated. Regards, Simon

Hi, I'm creating a print production database and at the 'Job' level I'm confused over what do with the table structure. Each Job has four different procedures - Pre Press Production Finishing Delivery I had thought about keeping all of the these in a single table called 'Job Procedures' related to the 'Job' table by 'jobID', however each of these procedures is slightly different and in the simplest scenario some procedures may have 3 records per job whilst some have just 1 or even none. That being the case I am worried about creating nulls in some fields and therefore thought I should perhaps create separate tables for each procedure? Does anybody have any experience with this kind of business or structure? Kindest regards, Simon

Hi, Has anybody any experience of linking to Apple Address Book using Filemaker? Is it possible to have 2 way updating? Best regards, Simon

Hi Comment, I just got the relationship working and discovered what you mean. Would a preferable method be to list the matching records using a portal and then perform a GTRR to the single related record only? Thank and kind regards, Simon

Hello, I have worked through how to create a portal that displays records that are restricted by a self join. BUT ... is it possible to do this using a layout as follows: I have a table that has jobs, and these are either quoted or live jobs. I have a field called 'Status' that is populated from a value list with either "Job" or "Quote". I want to be able to create a layout that only shows 'Quotes' as a result of using a self join. I've temporarily solved using a script trigger that forces a find on 'layout enter' but it's not the best solution. I'm sure I'm just missing something simple as I worked out how to do it using a portal ... but now I'm very frustrated. Best regards, Simon

Hi, That's great thank you so much. Was working far too late last night couldn't think and this really helps. I'll be able to use this elsewhere too. Thanks, Simon

Hi, I created the 'contractor skill' table so I can select the various skills using a portal on the contractor table but have come across the problem of being able to select the same skill more than once. Is there any way to prevent this ... current fields in table as follows ID / skillID / ContractorID linked on one side to skills table and other side to Contractors table. Can't think of how to prevent duplicate entries via the portal? Help :??? Regards, Simon

Hello, I'm developing a database where I allocate work to a number of contractors based upon their skill i.e. carpenter, electrician, plumber etc. Some of them may have multiple skills. Question 1: Should I set up a table that lists the skills for each contractor i.e. one to many relationship if so, understand how to do that but then getting stuck on the process of how to us this information to allocate the 'job' The 'job' table has a field that corresponds to carpenter, plumber, electrician etc. Not sure how to link these? Thank you in advance. Regards, Simon

Hi Barbara, Thinking along same lines as your recommendation could if i wanted to restrict users from a particilar company to only see 'their company' data could I create a 'company' table that contains fields - user id, company name, company number ... etc, save the company number as a variable in an open script like you suggested and then auto populate with this variable whenever a new record is being created or subsequently viewed. Would I have any issues with variable name if there were more than one user in the database at once? Or would there be a better way of achieving same result, i.e. multiple users from different companies only being able to access their own company data? Regards, Simon