Inventory database

[spudracer]

I've built a few databases in the past, but I think this is the most complex that I've ever wanted to get going.

I haven't built anything yet, and my training has been based on trial and error, but I don't even know if I can do what I am invisioning.

What we've got:
- Database where all items are logged and idenitified by the offices that actually hold said items.
- Transfers, at the moment, rely on the user going in and clicking each item to transfer, then go through and change the location of each item. This can be time-consuming for a lot of items.

What I want:
- A form where two offices can be selected (From/To). Items can be selected on the From side that will be transferred over. No items currently on the To's inventory should be seen.
- Once all items have been selected for transfer, a report can be generated and the location will be updated automatically.

Seem simple enough? I'd like to do as much as this as possible, so if I can get some pointers or a warm hand to hold while I work this, I'd appreciate it.

 

[pbaldy]

My wife says my hands are warm; does that count?

Seems simple enough. Don't know your structure, but I envision 2 combos for the from and to locations and a multi-select list box that limits its selections to the from location. Behind a button is a standard loop of the selected items executing SQL to update each record, using the to location combo and list box value.

 

[spudracer]

My wife says my hands are warm; does that count?

Seems simple enough. Don't know your structure, but I envision 2 combos for the from and to locations and a multi-select list box that limits its selections to the from location. Behind a button is a standard loop of the selected items executing SQL to update each record, using the to location combo and list box value.

That's what I thought, as far as it being fairly simple. My struggle is with the execution. Of course, SQL is an area that I have not gotten to familiar with.

I'm going to plead the fifth on what your wife thinks of your hands.

 

[pbaldy]

Dive in with the interface, and if you get stuck post back and we'll sort it out. I'd do the listbox selections based on the "from" combo like cascading combos:

http://www.baldyweb.com/CascadingCombo.htm

 

[spudracer]

Paul,
You previously helped me on my last database. I'm using the same one as the springboard for this new database, I'm just stuck on my tables and what needs to go where (this was over a year ago and I've had so much crammed in my brain since then, I don't remember ).

I'll attach that database for reference.

Here's what I think I need:
1 table for offices
1 table for items
1 table for what items are where

After that, is where I get hazy. Any assistance is appreciated!

 

[pbaldy]

I'm not sure what your question is. The third table sounds like a typical many-to-many junction table between offices and items.