eighthman11 wrote:
Hello everyone. I thought I had a perfect plan but obviously I don't.
I created a continuous form which list all our company's inventory.
The Continuous Form has the Inventory Number, Description and Quantity
on Hand. The Continuous Form is based on a Query. That works great.
I placed an unbound text box on the form so people could enter a number
next to each inventory item that they may need for a project. You
would enter all the numbers hit update and have an inventory list of
all the items plus quantities you need for a project.
Buuuuuuuuuutttttttt when you enter a quantity in the text box I
created all the text boxes next to each inventory item gets filled in
with the same number. Have I approached this project incorrectly. Any
help appreciated.
Since the field is unbound, the same "field" is displayed in the form.
You will need to adjust your input method. You can add a field to the
inventory number. Most likely this won't work since you are also
displaying qtyonhand.
You may need another table. This would link to the project. Here you
could store the date entered, the emp that entered it, and the qty.
This will work better. If there's only a 1-1 correspondence that will
make it easier. Let's say tho you have ProjectA, and invoice item 123
was selected by Jack and he needed 5 and Bill needed 4...in otherwords a
1-many relationship, you could use a subform to display those. When you
go to a record, you'd requery the subform.
There's many ways to go about this...but not the method you want to use.
It's like if you have a list with a combo for customer contacts. On
each row you requery the combo to display the contacts for that
customer. Well, you select Jack on row1 and then go to row2 and select
Bill. Bill will now show in both. What some do is dbl-click on the
field, this calls another form where you can select the values you want,
then when it closes update the row you are on correctly.
