Supply Database Setup

[djkc]

I am coming up at a loss on how to design this particular database. I
exported from Solomon my inventory list of supplies for my branches as a csv.
I imported it into a table that has the Inventory #, Description, Cost, Item
Location, & Qty. I need to lock this database so that it cannot change. I
want to have a supply form so that my branches can open a form in access, see
this list and place the quantity by what they need. Once finished, I want the
form to be saved but not the table that has the master inventory changed.
Please help!

 

[KARL DEWEY]

I want the form to be saved but not the table
Forms do not store data, only tables. I think you need to do some more
reading before beginning your database.

 

[djkc]

I know that part, I'm just wondering how to have the inventory list saved as
a master and when the branches input their orders it goes possibly to another
table?

 

[Jeff Boyce]

I'm with Karl, you'll probably want to spend some more time researching
"normalization" and "relational database design" before trying to create a
relational database. Access is not a spreadsheet on steroids, so if you
have experience using Excel, you may have to UNLEARN some things!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Fred]

Dear DJKC,

If the other guys are thinking the same as me, perhaps I could add an
explanatory note and an additional suggestion.

Instead of describing what you are fundamentally trying to do, you,
inadvertantly, in essence, created a misconception on how to do it, posted
your misconception, and then asked people how to make your misconception
work.

Not many volunteers want to start from a point like that. You might want
to repost but just describing the nature of your data and in plain terms,
what you are trying to do.

Sincerely,

Fred