Advice on setting up membership database

P

Pete

I wish to set up a membership database that will keep details about my
members and the equipment we install for them. I also wish to keep
track of all items we have in stock and out in the field. When we
create a new member, I wish to be able to dedicate pieces of hardware
to him e.g

Fred Bloggs
Address
etc etc

Hardware used etc

Access Point WAP011A
8db Panel Antenna
2m SWA extension lead
Wireless Radio Card
Date installed

I also need to be able to manage the number of the number of above
items we have in stock, so need an inventory that increases with new
stock and decreases when installed

Can anyone start me off, or help me with the layout of the tables &
relationships

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top