Import, Update, Add

[Jrenter2]

Hello folks,

I am new here and really need some help as this is totally “new” to me. I have been asked to design a program for a biomedical company to track their work orders and testing at various locations. I have been able to accomplish taking the file that is transmitted from the testing equipment and import the information into a table (equiphold) and have it available for updating the rest of the database.

What I now need to do, and don’t know how is to take that table (equiphold) and generate a new work order for each piece of equipment tested and Update the existing database (create new work order for that piece of equipment and have it’s test results within the history) along with the information provided for existing equipment and if there are new pieces of equipment have the user be able to add it to the database along with the test equipment’s readings.

This program is for biomedical testing of medical equipment. It has all the regular stuff like inventory, parts, work orders…etc… Work orders can be created one by one…but, when the “testing equipment” goes to the field, each piece of equipment tested has its’ own readings and needs its’ own Work Order when it gets put into the database.

The testing information would go into the W/O Task listing for a particular piece of equipment and if a new piece needs to be added, the user can add the new piece tested and then have the associated results along with it.

The following are some of the tables from the database that would be used.

1). Equiphold – { the table that holds the uploaded/imported information for new/tested equipment).

2). Equip – (Table that hold the equipment information)

3). WOHead – (Table that holds the Work Order Heading Information)

4). WOTask – (Table that holds the “testing” results).

5). WOHistory – (Table that holds the work order history for all equipment)

I hope this all makes sense to you all. If not, please let me know and I will try and clarify.

Any and all help would be greatly appreciated or if anyone has a “similar” program, please respond.

Thanks in advance.

Jrenter2

[hyperpau]

Hello folks,

I am new here and really need some help as this is totally “new” to me. I have been asked to design a program for a biomedical company to track their work orders and testing at various locations. I have been able to accomplish taking the file that is transmitted from the testing equipment and import the information into a table (equiphold) and have it available for updating the rest of the database.

What I now need to do, and don’t know how is to take that table (equiphold) and generate a new work order for each piece of equipment tested and Update the existing database (create new work order for that piece of equipment and have it’s test results within the history) along with the information provided for existing equipment and if there are new pieces of equipment have the user be able to add it to the database along with the test equipment’s readings.

This program is for biomedical testing of medical equipment. It has all the regular stuff like inventory, parts, work orders…etc… Work orders can be created one by one…but, when the “testing equipment” goes to the field, each piece of equipment tested has its’ own readings and needs its’ own Work Order when it gets put into the database.

The testing information would go into the W/O Task listing for a particular piece of equipment and if a new piece needs to be added, the user can add the new piece tested and then have the associated results along with it.

The following are some of the tables from the database that would be used.

1). Equiphold – { the table that holds the uploaded/imported information for new/tested equipment).

2). Equip – (Table that hold the equipment information)

3). WOHead – (Table that holds the Work Order Heading Information)

4). WOTask – (Table that holds the “testing” results).

5). WOHistory – (Table that holds the work order history for all equipment)

I hope this all makes sense to you all. If not, please let me know and I will try and clarify.

Any and all help would be greatly appreciated or if anyone has a “similar” program, please respond.

Thanks in advance.

Jrenter2

I can't understand you. You have like a one whole paragraph fitted into just one sentence. Please use periods to separate each sentence.

To better assist you, give me a picture of what the form would look
like.
Example: there is a combo box that contains what?
Regarding creating Work order, I think what you want to do is to make
an incrementing number for each tested equipment?

[Jrenter2]

Hi Hyperpau. Sorry for the long sentences. Yes, I want to have incremental Work Orders created from the imported information that is sitting in a seperate table.

In one screen (Browse Work Orders), there would be a control box that has 6 columns in it. The columns are labeled as follows:

W/O Number.....Cont rol Number... Device....Date Opened....Date Closed....Tech
....000187..... .......GAL100.. ..........Pump. ....... 6/7/07........... 6/8/07........... JR
....000186..... .......GAL101.. ..........Defib ......... 6/7/07........... 6/10/07.......... JR

On the Equipment Screen....there is another control box that has that has 4 or more colmns. They are labeled..

W/O Number....Date Opened...... Date Closed.....Tech
...000187...... ...... 6/7/07............. .... 6/8/07...........JR

At the bottom of the screen, there is a command button labeled "View Work Order Details" which would allow the user to highlight one of the WO's and open it up and look at it for that particular piece of equipment.

What I want to do is take the information sitting in the imported table and transfer the information over to the table that has the Work Orders in it and have it create the next Work Order Number automatically and delete the row from the imported table.

Also, if there is a new piece of equipment (based upon the Control Number) that has been tested, it needs to be able to be added to the equipment table first and then create a work order for the testing just like the other equipment.

I am not sure how to go about doing that through a "Update Database" comman button.

I have screen shots of all of this if anyone wants to see "EXACTLY" what I am talking about wanting done. I am not familiar with posting an image on here to do it now or even if it's allowed.

Hope this reply helps clear things up a little bit.