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
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