equipment control db

[scottappleford]

Hi

I am new to db and would like to do a simple db for items of equipment going out and coming back in showing who has been allocated what.

So one person could have many item but the item can only be issued once until it is booked back in. I would also like a history of transactions.

Only something simple, so we have a record who has what if we need to find something and when they had it etc.

Many Thanks

Scott

 

[ColinEssex]

So what have you done so far? Hard to tell from your post what the problem actually is

List the tables you have, and their relationships

Col

 

[neileg]

There are often questions psoted about this form of application. Do a search and you may find some examples that will get you started.

 

[scottappleford]

Thanks for helping

Hi Neil

Basically i have not done too much.

I create three tables.

One for the employee - name, department etc
One for the Equipment - make, model etc
One for the transaction - date out, date in etc.
I then put the employee id and equipment id fields into the transaction table and created a one to many relationship - one being the employee/equipemnt and many being transaction.

I then created a form but thats as far as i got because it will not let me enter data?

Thankyou

Scott

 

[scottappleford]

Thanks for helping

Hi Neil

Basically i have not done too much.

I create three tables.

One for the employee - name, department etc
One for the Equipment - make, model etc
One for the transaction - date out, date in etc.
I then put the employee id and equipment id fields into the transaction table and created a one to many relationship - one being the employee/equipment and many being transaction.

I then created a form but thats as far as i got because it will not let me enter data?

Thankyou

Scott

 

[neileg]

You have a many to many relationship. Your transaction table is known as the junction table. It should hold the PK of the equipment and the PK of the employee.

Do a search in these forums for many to many relationships. There's plenty of help.