inventory calculation

[randomtask976]

how can I add a value to each item ?, it is drop down field that contains 50 items ?

lets say I pick item 1 in the field and have another field add for instance a QTY.

thanks

[Anuviel]

Ok, so you have one field which has a value list assigned to it and that list contains 50 items.

What do you want do achieve?

Are you trying to have one more field that would have a drop-down with possible quantities or you want to choose the item form the first field and then enter quantity into the second field and hit update button?

Also, is the value list for your first field custom values or values from a related field and where are you going to have your results displayed?

A bit more information as at least I do not get what it is that you are trying to do.

***** Disclaimer ***** Always get a second professional opinion before taking my advice

[randomtask976]

sorry for being a little vague,

this is what I am trying to accomplish,

I select an employee number, for this I have a pop up box, ( I have this already) then I have another field with a pop up box that lists materials (20 repetitions), ( I have this already)

now, I want to have another field that enters automatically the quantity of that material,

for instance I enter BOX OF NAILS in the drop down menu, I want another field that automatically enters 100 pcs per box,

when I select Hammer in the drop down menu, I want it automatically enter 1 as the quantity

ultimately, I want to be able to run a calculation on individual persons on how much stuff they consume, but I am just having trouble linking the quantity with the individual product

it would be ok if the initial materials list would have this number, but I do not know how I would run calculations from it

thanks

thanks

Edited October 10, 2007 by Guest

[Anuviel]

Thanks, I'll try to see if I can help with this...

Do you have an inventory table where you store such information as hammer, quantity 1 and so on about your items?

Basically how I would set this up would be:

I would have an Employee table, Inventory table, Line items table and Invoice table so to speak.

Employee table - store the information about employee such as employee ID, name and so forth

Inventory table - store the information about items such as item name, quantity and so forth

Line items table - you will use this to enter information about the employees and their use of the items and run your reports

Invoice table - create the invoice or a job or whatever you want to call it for the employee that you will be tracking

I attached a file I just made - it is quite simple and I wrote some explanations in it as well - should give you the idea of what approach I took here - hopefully you will be able to adapt it to your file or get the idea how to do what you are trying to do.

If the above does not work for you you might want to lookup a conditional value list and a self join relationship so that when you choose hammer from your list only the related quantities will display in the second drop down menu where you want to show the quantity

Hope it helps

Example.zip