A repetition question!!!

[Farlau]

I have a tow dbfile 1.is Order. 2.Technacian.

In order datebase,if make a new order we have 3 services time provide to our customer.

The problem is, I want to make a monthly report,to sum our Technician working time.

A Fields is (Total Time)repetition 12time

B Fields is (Technician No)repetition 12time

The case will,in one order maybe have 3 different Technician No:

I don't know how to make a report to sum the Techician Working time!!!

Like This

Can someone help me??

Sorry that my english not very good!!!

[ernst]

Hello Farlau,

The problem with this is that you are using repeating fields. That makes it impossible (or at least very hard) to make reports.

You should reorganise your database(s) to get rid of the repeating fields.

I think that you would need the following databases:

Orders

Technicians

Clients

Labour

Some would refer to the Labour file as the Line items file. It is the file that holds the 'lines' of your Orders.

The Labour file would be replacing the repeating fields you use now, so you would need fields in labour for:

OrderNumber

TechnicianCode

ClientCode

Service date

Service time

Total time

AC

Remarks.

Then you should define relations in you Orders-, Technicians- and Clientsfile to your Labour file that allows you to see the lines belonging to one Order, Technician or Client.

In think that you should use the following fields for that:

-Orders: relation from OrderNumber to OrderNumber in the Labour file

-Technicians: relation from TechnicianCode to TechnicianCode in the Labour file

-Clients: relation from ClientCode to ClientCode in the Labour file.

In the relation you define in Orders you should check the "Allow creation of related records' flag, so that you can easily create new Labour records.

The last step would be to define portals in the layouts of your Orders-, Technicians- and Clientsfile that show fields and records from the Labour file.

I hope that this helps.

One condition though, next time I get free towing, yes?

Regards,

Ernst.