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

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

Lionel, I got a neck ache from trying to look at your form.

What is the significance of the printed part at the top, and the handwritten at the bottom? or in this case, the right from the left lol.

Why not attach a copy of your database?

Lee

Lee

This what I would like to accomplish

Thanks

Lionel

continunity records_log.zip

Your file was looking for a Table called "value lists" or something.

I made a quick report to see if I'm understanding your request.

OOPS, I forgot to change the name of the file, so be careful not to replace your existing Main.fp7

main.fp7.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

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