beckham

Thank you comment once again, you make it appear so obvious ! I keep over thinking these challenges... Ill try your suggestion, Top Man!

Is it possible to find matching records in my database using a list of imported records. my existing database contains a field name BinRef and contains a seven digit variable e.g.: 1234567 plus an ImageRef which always has 5 Digits 12345 I have another imported table which contains up to 100 records with examples of the variables i need to find in my database above. Without manually finding every match using the "new record request" how can i script a find function that will match all 100 records in my imported table. ? Thank you in advance to all Guru' who can help.

conditional Ok as often I have answered my own question, for any newbies with the same question. formula = field A = "Mrs" and field B = "Mrs"

Hi, can anyone help with considerations of my first attempt at charting in filemaker. I hope to show a colum chart (sales v wages) on a weekly basis, with the chart displaying actual data and the percentage wages represent against sales? Thank you for any advise...

Answer to my own question, I found an error in the setup i failed to identify the "include only related values checkbox"

Following Lee's advice i have succesfully managed to create a conditional value list, but i have have a strange problem. The conditional popup menu (or drop down) is very slow at propagation of value i.e.: the list that matches the condition can take minutes to load or change based on the trigger condition... any idea how i can speed this up? Thanks...

Thank you Lee i found the you tube link earlier and another one by Guy Stevens but didn't understand how to relate those examples to my file. Your example file is most useful i will check that out in detail. kindest regards..

Hi can anyone advise how i can make a simple value list conditional? I have a single table on a job bag system and one field specifies the choosen print supplier i.e.: "London Print ""Wards Print" etc. I would like the detail fields such as "Foil Colour" to be conditional because different suppliers have different references to the colour swatches.. e.g. London Print may use "RED032" where Wards Print could use "BlazeRed" I only want to display the user the values specified by the choosen supplier.. i'm not sure where to start? I think i need to create tables and relationships but would appreciate any help thats out there on the forum... many thanks

Hi Lee, Thank you for the sample file i am most grateful .. even lloking at the sample file i dont yet understand this witchcraft used in Calc fields but i am able progress my solution further with your generous help... Thanks again..

Help Please, I am trying to figure out how to extract field contents via a calculation as follows: My lookup field is ABCDEFG-01-12345.jpg I want to automaticaly extract only 12345 to be placed into another field? I tried the Calculation Right ( Sorce field; 5 ) but that returns me 5.jpg any adivise is most welcome. Thank you

OK I can answer my own question now, i created another field to target the import to and I used replace field contents "Left (Design) (7) ) to look up the target data. This new field then only held the "AB12343" part.. which i could use to update matching records in found set. If any other newbies have a similar puzzle..

Hi Guys can anyone advise me please with my following problem. I have a database (FM15) containing a field populated with the following example "AB12343-02-12345" I want to import a csv using "match existing records" matching only the "AB12343" element of the existing records. Then a new field is used to store the imported "AB12343" because i don't want to overwrite the completed field of "AB12343-02-12345" if no match exists it will create a new record. A big thank you for any Guru help on this!

Thank You for the sample file Lee that helps me understand the options i have much better. kind regards

Hi can anyone offer advise on the best practice to script a find function please? I have a "expiry date field" e.g.: 12/03/2018 and would like to have a script that could show records that fall within 8 weeks before or after the expiry date. Thank you

Thank you so much...