Database Access 2007 Trouble

[WayneSteenkamp]

Hi,

I'm starting this over again so I can have all the answers I need in one thread and not multiple ones.

The database I'm doing at the moment is near completion, for what is needed of it anyway. The user has requested a few extra tweaks which I have been able to do, though there is a couple which I desperately need help on.

First of all to give you a slight insight of how the database needs to run:
The database is to record and log where the SimSerialNumbers and ASE Units are. i.e whether they are assigned together, which site are they installed, if they are faulty - what's wrong, what unit/sim is replacing which if damaged etc.

There's 4 tables, ASE_Units, (ASE)Repair History, Sim_Serials and SimSerial_Repairtracker
The ASE_Units and the Repair_history are on a form together - Repair_history as a subform.
The Sim_Serials and SimSerial_Repairtracker are on a form together - SimSerial_Repairtracker as a subform

The User wants to record the ASE_Units and if theres a fault etc to it, the Repair_Tracker is filled out. The Same applies for the Sim_Serials and repairtracker. Except the Sims get cancelled on the repairtracker.


The Question is: The user wants to know if she fills out the SimSerialNumber in the ASE_Unit form - The data will populate not only the ASE_UNit table but the SIm_Serials table aswell? She doesnt fancy enter the Sim data twice - one in the Sim_Serial form and the other in the ASE_Unit form. She only asks this because some Units will come with a Simnumber. All other Simnumbers that are on their own with be entered in the Sim_sErial form.These Sims will have a status :"Unassigned"


Brings to the 2nd question.
** Mod comment **
This may be specified in a separate thread, but only one question is allowed per thread.

Hope this makes sense.
I've attached a print screen of my relationships, which I think may be incorrect. Especilly the Middle part when the SIm_serials and ASE_unit is linked. It doesn't seem to be doing anything. This because The SimNumber in the Sim_serial table is already in use?

[twinnyfo]

Wayne,

If I follow you correctly, the Sim_Serials.SimSerialNumber may or may NOT always be in the ASE_Units table? If this is the case, then, when one enters a SimSerialNumber from the ASE_Units form, you could simply append that SimSerialNumber to the Sim_Serials table (multple ways to do that). This would preclude the need to enter it twice. However, it looks like the Repair_History and Serial_Repar_Tracker tables have slightly different data attached to the SimSerialNumber. I guess some of that data could also get transferred via an append to the respective table.

Not sure how much that helps, but might get you in the right direction.

Warm Regards.