Hi to all,

i am trying to make a solution to monitor Aircraft maintenance.I am currently stuck.I want to take a record from my task list of a specific aircraft,and make a workorder list that generates an ID for the workorder(for the specific aircraft) for future indexing.So i need to get that record ,copy it to a different layout(workorder layout)put an ID and be able to print it.I was thinking that i might need another table but i am not sure if it will work as i want.

Thanks

Anyone?

FYI-it's best not to bump posts on this forum. No Replies are easier to find, and many of us troll that list when we're looking to help.

Anyway, I'm willing to help. Can you tell me what tables you have? From your post, you have Aircraft, WorkOrders, Tasks, what else?

Please expand a bit on the business needs.

Sorry about that.I have 2 tables Aircrafts and Maintenance tasks.I will make one named as you said for workorders.I have entered tasks but i need to print these tasks to the technical department to get them done.the form has to included an ID number per Aircraft to keep them in logbooks.i have made the reports but i want to make a script that will get the record (not all fields)and print it with a generated ID(serial).So i need a table that will store the tasks per aircraft.Tables are related with the Aircraft registration.

Edited September 3, 200916 yr by Guest

Are maintenance tasks items that repeat? For example, "Oil Engine," could be a maintenance task that is repeated time and again for many aircraft. If so, I suggest that you have a table for these tasks and use it like a task library.

Then, assign tasks to an aircraft by creating a Work Order and WorkOrderLineItems. Each WOLI has a taskID.

Here's a demo

Aircraft.fp7.zip

I need the tasks for separate reports.I am attaching my solution so you can see what i am after.Check reports by hour to see what i am trying to do.From there i want to print individual "workorders".

Check

02-09_Copy.fp7.zip

Please take a look at the demo I posted. I think it'll be very helpful. Your reports would be created from the WorkOrderLineItems table.