Auto Creating Records

[OU18]

All,

I am in need of a way to auto create records based on a circuit level field. I have been tasked with creating a circuit inventory DB to track company facility assignments.

Scenario: A user is entering a new facility assignment.
IE OC48. Which is assigned a unique id (autonumber).

When this record is created, I need the system to look in the circuit level field and automagically create 48 spare DS3 level circuits that will have the OC48 unique id assigned (for linking purposes) to create a hierarchy of circuit assignments.

I will obviously have to do this for each hierarchy in the circuit scheme.

OC48 - Create 48 DS3
For each DS3 - will need 28 DS1's associated to them
For each DS1 - will need to create 24 DS0's

These will all depend on which circuit level is selected.


How can I do this.

Fields
UniqueID - AutoNumber
CFA - Text Field
CircuitLevel - OC48;OC12;OC3;DS3;DS1;DS0
SwitchA - Text Field
SwitchZ - Text Field
Slot - Number field

These are just some of the fields.

Thanks for the help everyone, I appreciate it

 

[Bastien]

linked tables

main table
OC48

subtable1
DS3

subtable2
DS1

subtable
DS0

Use one of the events (onBlur, onUpdate etc) to fire a macro that will create the needed number of records in the other tables


Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[MichaelRed]

At least in the more traditional sense, you would not create the 'daughter' records until they were to be filled with other meaningful information. If that (meaningful)info is avaialable, it should not be an issue, although there may be significant effort and/or questions involved on the rationale for doing so as well as technical questions on the retrievial of the information and generation of the records. You will be generating ~~ 32K records in your system for each occurance of an "OC3" record. At least initially, the largest part thereof would appear to be meaningless (empty of all except the PK/FK).





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[OU18]

Bastien,
Thanks for your input

Michael,

I can see what your saying. This is a request from the department head. They want to be able to show all available and assigned SLOTS on a particular Facility. Whether they are spare or being used. It is a capacity management issue. They dont like the idea of only showing the assigned circuits on a Facility. They want to take the guess work out of people trying to figure what the next available CFA is.

I can definitely see what your saying about the amount of records.

They want an idiot proof system, but just when you think you have accomplished that, someone comes along with a new and improved idiot. LOL

 

[Craig0201]

Michael's comment still applies.

You need to find a way of showing this on screen without storing virtually blank records.

Craig

 

[MichaelRed]

An approach might be, since you woould know the total numbers, and therefor the sequence sets, would be to index the relevant parameters and use some code to generate a dynamic array of what is available, filled in with the records of those which are occupied. Displaying the array would seem to show the 'whole' picture, withopout the additional storage. On the other hand, I don't envision the display of 32K anythings being at all useful for human consumption.

A better approach -in my humble opinion- would be to perhaps generate a simplpistic graph/chart, with the MAX representing all possabilities of the unit, and the bar representing the "used" part (slots / circuits?). Even there, you would be representing WAY more info than pratical, but it could still avoid the wholesale generation of blamk space.

You should take some initative (responsibility) here to look at the issues such requests address and provide reasonable feedback to the organization.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[OU18]

I couldnt agree more with all of you. Have you ever pled your case, and felt like you were talking empty space.

That is where I am at.

But I will figure something out.

Thanks for all the advice

 

[MichaelRed]

better (or at least as necessary) to start figuring out where you are going while employment opportunities are scarce, working in the vaccuum is not healthy.





MichaelRed
m.red@att.net

Searching for employment in all the wrong places