Hello,
I'm really new in Access and i'm trying to make Hardware&Mobile Pohones and Blackberry inventory. I have clear idea how DB should works but i need your know-how to complete my ideas. So my plan is to have one table called Invetory DB where I will have all stuff like computers,notebooks, mobile phones Blackberies etc. which serial numbers and status( in Use, in Stock, In Service). I need there also name of user who has this stuff asigned. I need also create form for new joiner which will ablle to fill my main inventory DB and form for asigment in case when i need asign new BB mobile phone or whatever to user.I will need create query of computers in stock BB in stock etc. and query what user has asigned. Hope that my idea is clear in case if not please let me know and i will clarify.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Well, i think that it is a good start, but i have two more questions. First one is How should i setup a relation ships between tables and second one is how can i setup a cascading comboboxies for example in new joiner form i choose that user has desktop after that second box will appear and i will choose one of four type what we have here.
Thanks
1. <but i have two more questions.>
You are only allowed one question per post.
2. <How should i setup a relation ships between tables>
Since you did not mention what Access version you are using, I will give you a generic answer.
Open the relationship window and add all the tables.
Then you simply relate the matching keys.
For example,: drag DeviceCategoryID (Primary Key) from tblDeviceCategory, ...to DeviceCategoryID (Foreign Key) in tblDevices.
(and enforce referential integrity if need be)
Business Accounts
Answer for Membership
by: boag2000Posted on 2009-09-03 at 13:30:23ID: 25254631
This should get you started...
tblDevices
DeviceID (Primary Key) (Serial Number?)
DeviceName
DeviceCategory (Foreign Key)
...etc
tblDeviceCategory
DeviceCategoryID (Primary Key)
DeviceCategoryName
...etc
tblUsers
UserID (Primary Key)
UserFName
UserLName
...etc
tblUserDevice
UserDeviceID (Primary Key)
UserID
DeviceID
DeviceAssignDate
tblService
ServiceID (Primary Key)
ServiceName
...etc
tblDeviceService
DeviceServiceID (Primary Key)
DeviceID
ServiceID
DeviceServiceReason
DeviceServiceDate
...etc
JeffCoachman