The Big Bear

Tom I am Sorry for not having the FM edition. I am using FM10 advance. Now you have me curoius about the two tables. The continunity table has the welder ID and the Welding process and the date Welded and the expiration date as fields. I do have a table that has the welder information as Name, ID number, and Stamp but this table is not connected the the continunity table. I think I have a data structural problem. The continunity log file has only one date field called 'DATE WELDED:" There is another field called process that captures the welding process (i.e. GTAw, SMAW, FCAW, etc.) To make each record unique, I have a field that combine the ID number, the Date welded as a number and the welding process.(i.e. 2345 SMAW 768902) That could be the problem. How would you suggest that I construct the continunity log table. Thanks for the information, will give it a whril. Lionel

Tom I have two tables one with the welding information called "Continunity" and another table called " LIST" with the script in the calculating fields. Is this the right setup? I do not understand how the calculating fields known what record number to capture as the way I have is setup thet do not capture any recorder number. I understand how is it done but cannot did it to work. I made five calculating fields in the TABLE "LIST" as follows: Gobal, = GETVALUE ($$smadates;get(recordnumber)) Then I wrote a looping script in the table "LIST" as follows: Set Variable ($$ smadate; value(continunity::SMAW dates)) for all five calculation fields I am not sure on what field or fields that I should make the relationship on. no informatin is shown on the list table I do not have have winzip so i cannot post a copy of the files. Thanks for all the past help Lionel

Tom Thanks for the information. I read up on virtual table but still not sure what they are or how to create them. If you would go into a more detail on how to gather the dates and make a virtual I would greatly appericate that. Thanks for all your help in the past. Lionel

Olly I do not have FM12 but in FM10 when you make your value list click on the box that states " Include only related values starting from" and chose the filed you want to display. Hope this helps Lionel

my past experience with portal print has not been good. Portals only print what you can see on the screen. Some of these welders have at least 60 entries for each welding process. thanks Lionel

thanks for the reply I cannot open zips files at this moment. I tried using a separate portal for each welding process and that work perfectly for display purpose only but I would like to print a report as shown in the third example. Lionel

Hi all Been trying to figure on how to do this for a couple months now and as you can see I am not to good on relationship. I attached three jpeg file that I hope explain what I want to accomplish. After verifing that a welder has welded in a welding process that he has been quialified for, I log the date in a continunity file. This need is done for ever six months of employment. The file continunity example show how each individual record is recorded in the file. The continunity have example is how is print on the form that is posted in the foreman office. The continunity want is how I would like it to print. Thanks in advance.  Lionel  Â

Hi all I know i have not been to clear on what I have been trying to do but I hope I can state what I want to do in a clearer manner this time. When a welder qualifies using a welding process, a continunity log record is create in the continunity log table. These records are created in random order because a welder may test in one welding process to day and another welding process next month. The continunity log consist of five fields. Date welded Welder ID welding Process unique field Serial number There is about 200 record for 6 active welders in the continunity log table. A new record is also create every two (2) month to show continunity for each welder for each qualified welding process. I tried a calculation fileds that work some what. I tried to acomplished this through a relationship but have no success. I figure it would be a combination of a calculation and a relationship. I have attached two pdf files and a copy of the short version of the continunity file. Any ideas would be help Lionel continunity report now.pdf continunity report want.pdf continunity log main.zip

Lee Thanks for looking and I am sorry that I did not explain myself to well with what I was looking to accomplish with the program I send you. I have made a couple of changes that I hope would help explain it better. I really appreciate the time you have took to help me with this. main.zip

Lee This what I would like to accomplish Thanks Lionel continunity records_log.zip

Hi all This is what i am trying to accomplish. I have a db that has all the monthly dates that each welder as welded for each process thet are qualied for. The db is setup as Date welded Process Welder ID unique number I want to made a report for each welder as shown the the original post. I perform a find on the welders ID number and sort the records by process and date welded the FCAW process would be the first set of record that are displayed on the list layout. So these record would start on the first line and so on. Then the GMAW process would be the second process displayed on the list layout but the dates are not display until after the FCAW dates. I would like all the processes dates to be displayed starting on the first line. I tried a calculation field but it does not work properly. case(isempty(GMAW_Date);getNTHrecord(GMAW_Date;Get(Recordnumber)+1);GMAW_Date) But that will only populate the last record for the FCAW process. Maybe a loop script would be better. any ideas and help wouuld be greatly appreciated Lionel

why don't yuo just add another classification and name is NONE. what way it would be in the list

Hi all The first example on the sheet is done with a find and looping script but i would like to get all the dates to line up as shown on the second example on the sheet attached. Thanks in advance Lionel continunity form.pdf

Thanks

Vaughan A need to record each date that the welder use that process. and would like it to print each date under the process use . Print one page for each welder. Lionel

Hi all My company has 20 welders that use 5 different welding processes. We are required to keep a log on which welding process is being use by each welder per month. What I have a continunity log that shows the first day that the welder was tested and the last day that the welder welded using that welding process. I would like to print a report that would show all the dates that each welder used each welding process. I would like the report to be something like shown below Example: name GTAW GMAW FCAW Mark 2/11/2012 2/11/2012 3/14/2012 3/14/2012 4/12/2012 4/12/2012 4/15/2012 John 1/12/2012 2/12/3012 3/24/2012 3/11/2012 3/14/2012 Hope this helps. Any ideas would be helpful and appreicated. Lionel

Hi all I would like for advice on the structure of an estimating program we are starting to work on. I have the basic written down and included a PDF of what is will look like. The first layout has about forty or more fields with about 2/3 of the fileds being unique to that particular item wich would be the main component. The second filds has a bout thrity fileds. These two layout have only about 5 or 6 fields in common. The question is, Would your use one table too house all the records although many fields would not be completed per record for a component. example a separate table for LWN a separate table for WN Flanges a separate table for Steel Plate a separate table Misc information but all these tables would have one record or more records for each component. thanks in advance Lionel estpdf.pdf

Thanks Michael

Hi all I have 4000 records of steel in a separate table . Each steel is assign a grade and p number. The problem is that some steel p number changes with the thickness of steel changes. Example A36 steel is a p number 1 when the steel is less than or equal .750" in thickness But becomes a p number 2 when over .750" in thickness. User of the welding program enters the steel grade and the p number field lookup the p number. everything is good when the steel grade has only one p number but when the steel has more than one p number because of thickness the program has a chance of not being accurate. I tried a separate calculation field to populated the p number field when the p number changes but I must have something wrong because that did not work. Is there a way of looking up the correct p number when the steel p number changes because of thickness. Thanks for your help in advance. Lionel

I have a copyright runtime in FM. You send in the scripts you have written. Hope this helps Lionel

Nestor That is possible. assuming that you are performing one find from the table where the number is stored. You would need two find script, one for each table and using the set field command to enter the number in a global field in each table then the code for the first table would look something like this Enter find mode setfield(numberfield;globalfield) preform find if(get found count = 0) show message (No records found in this table, press the OK buttom to continue) else show message ( Records have been found in this table that meets your criteria) preform script(script from other table) Enter find mode setfield(numberfiekd;globalfield) preform find If (get found count > 0) show message (Records found in this table press the OK to continue) Then you will have to decide how you want to review these records. hope this helps Lionel

Shearton Instead of the salesperson typing in a name why not use a value list where the salesperson would chose the customer name instead of typing it. To find customers with similar names type in a partial name like Lion and FM should display any variation of Lion Lion Lione Lionel Hope this helps Lionel

I think you are looking for something like this Enter find mode setfield(effective_date;gobalfield) perform find. Hope this help Lionel

I am not sure what you mean about an option for show all record. If no records were found , you could use an IF statement. If found count =0 show all records end if Lionel

try this in a find script make to new gobal fields such as g_gender and G-type. make a drop list for each one that would show man or woman for the g_gender and a drop list for the other. enter find mode setfield(gender;g_gender) new record request setfield(type;g_type) preform find this should get you what you are looking for. Lionel