Searching/'Attaching' Records

[joynereh]

OK... here's my problem:

I have a MASSIVE database of our IT equipment and IP addresses. One of the forms for our techs to fill out in this db is something called a 'DRMO' form. Basically, when we get rid of equipment, they go here and create a record that documents who did it, what it is and when it happened.

What *I* need is the following:

I need, when they click on DRMO button from the Switchboard, the DRMO form comes up (I have gotten this part).

When they fill out the initial info: date, who, DRMO requested date and then the ACTUAL date that the DRMO happens (obviously an editable field).

At this point, I need them to be able to search the DeviceInfo records and find the equipment by serial number (already created). I need them to then be able to pull up that record in the DeviceInfo FORM, attach in a manner of speaking/reference that record to the DRMO form. At that point, when someone does a search for that serial number, they will find that it has been DRMOed.

Does all of that make sense?

I need to do basically the same thing with my CustRelocate form as well and my DeviceReplace form.

Can anyone help me?

 

[rainman89]

I would create a field in your equipment table called DRMOID or something like that. When you create a drmo you can then fill that date in on your equipment form and have a button or something that will link to that drmo record

 

[joynereh]

OK, this how I need it to GO... LOL

My Main Switchboard is laid out as follows:

1. Create New Inventory Entry
2. DRMO Request
3. Replacement Request
4. Warranty Issues

Now, what I need to really get done fully is this:

1. Click on New Inventory -> Open Default Entry (already created), input data -> Save/Close

2. Click on DRMO -> Open DRMO form (already created), input current date (auto-pop), technician (select, already done), DRMO request date (when it was requested FOR) and then DRMO completed date (when it actually happens, so this would be an editable field, I guess?) -> Click *something* and then be able to search 'DeviceInfo' records -> Grab record concerning DRMO equipment -> Edit with DRMO notation and entry ID -> Save/Close

3. Click Replacement -> Open Replacement form (already created), input current date (auto-pop), technician (select, already done), Click *something* and then be able to search 'DeviceInfo' records -> Grab record concerning DRMO equipment -> Edit with Replacement notation and entry ID -> Create a NEW Inventory -> Save/Close

Etc... etc... etc...

How would I do this?



I have attached screen shots of what I have in my tables for DRMO and DeviceInfo, just as an example.

 

[rainman89]

On your DRMO form you can create a dropdown to select the equipment that you want to "end" OR on your inventory page, you can put a drmo option on there that they can check and fill out right on the inventory page, removing the need for another form. Could also do the same with the replacement, so you can see thta its a replacement for blah blah, right on that page..

That is how we have it for our asset system