Hi,Hope this isn't confusing.
Adding to a system using phprunner, to track terminals we sell, lease and rent. Two types of terminals, wireless and desktop. Wirless have SIM cards, desktops have pinpads. all terminals, SIM cards and Pinpads have unique serial numbers. Terminals are assigned a TID - a unique id that is matched to a specific merchant. When a terminal breaks down, we swap one terminals/n for another, using that same terminal id. A serial number can only be assigned to one TID, or be in for repair. I need to develop a way to track everything.
So far looking at tables for:
terminal ids terminal s/n SIMs Pinpads
and then a final table (Terminal Setups)that links all the variables.
I'm looking for suggestions on how to setup this table. By setting up the info for each separate item, I keep track of specific info I need. This means I can use dropdowns for each item. But there are 2500 SIm's to wade through, as well as S/N of terminals.
And I need some way to restrict the terminal s/n so that they will only appear attached to one Terminal ID, or be listed in repair.
Any specific suggestions or idea's? All assistance reatly appreciated.
Any suggestions?