Asset tracking for SIM cards and cellular modems

[miket11]

Hey guys, sorry for the weird title as i really wasn't sure how to title it because I understand there are a lot of moving parts to what I want to do.

I'll explain the basic idea and hopefully someone can get me on the right track.

Currently I have different excel work books for these different things but these things are technically all connected in one way or another.

So lets begin!

I have a lot of cell modems and currently i keep the information about these cell modems in an excel workbook. Information such as Serial Numbers, IMEI, Modem Version, APN, etc.

Also I keep information for the SIM Cards such as the IP Address, ICCID, etc. These are dual sim capable modems so there are two sim cards.

These cell modems are installed into devices in the field.

These devices also have a lot of information that gets saved into a different excel workbook.

So for example lets take one device and call it device 1.

this device 1 has a Name, address, S/N, ID, Area, date of install, Etc.

a cell modem is then installed in this device and is no associated with that device but also not just the cell modem, technically the sim cards are associated with a modem that they are installed in.

So what I want to create as like a "program" or a form.

so lets say I need to install a new device in the field. I open this form up and fill out all the fields in the form, check mark if it is active or not active, etc. but also i want to be able to fill out the modem information and the sim card information.
So lets say i fill in all the fields on the form for this "new device" the name, address, location, etc and when i get to the cell modem part, i want to be able to pick a modem that might already be in the system. because some of these modems are already in the database. They just havent been assigned to a device. But for example if the modem in not in the database I want to be able to enter in new modem information. You know like when you check out on amazon, you have an option to "click here to selected payment" but if payment is not there you get an option to add a new payment which gets linked to your account. But the info for that payment in not really kept in the same database it is probably kept in the payment database but it is all somehow cross referenced to my account.

this is what i want to do here. these devices i want to be able to select a device and say "this device is associated with this modem and this modem is associated with these sim cards" one of the reasons for this is because these modems go out of service or a sim card stops working. A lot of times i need to replace a sim card or replace a modem but keep the sim card. or sometime keep the sim card and modem but replace the device.

and to keep all the information in one workbook is kind off a lot of info to scroll through.

Hope this makes sense.

Thank you all

[Logit]

Sounds like you want to create a simple database to keep track of the modems and sim cards.

Here is a simple database that you can expand upon as much as you want to satisfy your needs :

Please Login or Register  to view this content.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to consider amending your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Guideline #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

I have updated your title for you. However, I will recommend that you think about your question well enough to summarize in one line.

[miket11]

Thank you for the help. I'll try expend on what you have provided.