Need help! How to synchronize records in forms (Access 2003)

[eternalearth]

Hey guys, I have been working on a Computer Inventory Database for my office. I have it attached to this question (hopefully I did that right). I have it almost done, but the problem is, I can't get all the records to sync up in the forms. Especially since I am considering the possibility that one employee can have multiple computers/devices.



Please review what I am talking about, you will see what I mean. mariadatabase.zip mariadatabase.zip

Don't worry, there is no serious information in there. Just the form and the tables.

[RuralGuy]

A 1:m relationship is best displayed and edited using a Form/SubForm arrangement. Is that what you are doing?

[eternalearth]

I believe so. However, you should take a look at the relationships and also the form itself. Seeing it is easier that me trying to explain it.

Is there a difference between a Form/Subform arrangment and sticking a form (subform) onto a form?

[RuralGuy]

Is there a difference between a Form/Subform arrangment and sticking a form (subform) onto a form?

No...a SubForm is a Form that has been placed on another Form by the use of a SubFormControl. I'll take a look at your db.

[eternalearth]

Thank you

[RuralGuy]

The LinkMaster/ChildFields of the SubFormControl can contain more than one field separated by a semicolon ";". It can also point to another SubForm if required.

[eternalearth]

How do I accomplish this?

[RuralGuy]

Ideally, you would have separate Forms to define Hardware and Software so that the current SubForms would be using ComboBoxes to select existing records from these two tables. The way you have it now, you define hardware/software while looking at an Employee's records.

[eternalearth]

Existing records of employees or the inventory?
Cause we are always getting new inventory

[RuralGuy]

Where do you want to define new hardware and software?

[eternalearth]

With the Computer's of course I see where you were going with that. But I guess I am just a little lost on how I go about actually fixing it. If there was an example or some screenshots, i would appreciate it so much! I am so much better at visualization!

[RuralGuy]

I would strongly recommend that each software package be a separate record. As it stands now, if you want to track anything else, you need another firld in the record! Bad...bad...bad!
Since you have it set up that an employee can have more than one computer, what do you want to display on the hardware tab?

[eternalearth]

Please show me an example

I am getting more confused

I want the hardware.tab yo show its corresponding computer and the field of all the hardware related to that computer filled

[RuralGuy]

Maybe this is all you are looking for.

[eternalearth]

Holy cow! You did it! It would be so much more awesome if we could get the COMP ID to match eachother, but I guess it makes more sense to input them manually so as to ensure that the database doesn't mix up the numbers. Do you have any other suggestions or critiques? I may not be the best at the this but I really wanna know what I can do to make this better!