Newbie Database Question

[Iwantatransam]

Ok, My IT department has just purchased File Maker Server. We are wanting to use it for Asset Management, for Computer hardware, Printers, and software.

So far I have 3 tables, Computers, Printers, and Software. I've established a relationship across the field of "computer name" and it seems to be working, but I'm having problem with Relationships (I think) I have "Software Titles" show up as a checkbox in the Computer list, I have 3 software titles right now, if I uncheck a software title off all of them, the removes the choice from all the computers, and deletes the entry on the software table. we're wanting to keep license info, purchase order info under this as well, so I can't have it deleting things if we uninstall the software for a semester...

Also if I look at the software table, I end up with a lot of blanks fields under "title" and the computer name listed (under computer name).

what am I doing incorrectly?

[bruceR]

Pretty much impossible to say without seeing files.

[Iwantatransam]

Ok, so here is the file, this is just an early run version of the database, so no data is vital. Hopefully I didn't screw up too much.

Thanks for the help.

tmm.zip

[Iwantatransam]

anyone able to help?

[bruceR]

Mixing up the difference between available software titles and properties of a particular computer. Though the attached solves the problem your whole design needs to be improved, with more use of join tables it looks like.

tmm.fp7.zip

[Iwantatransam]

Woo!

Thanks for the help, I see what you did, and I'm able to take it from there.