List

smash54

Registered User.
Local time
Yesterday, 21:17
Joined
Nov 5, 2010
Messages
23
I have a db with 3 tables one is the employee table one is the inventory table. When a user logs on and goes to there inventory there are about 10 field boxes linked to the inventory table via a query. My problem is all of the inventory is one item but there is one thing there keys they could have multi keys. What would be the best way to enter them and view them on the form. We are giving all the employees one month to use this page to enter there inventory then we are going to change it to view only. I have tried a list box but that would only show the keys i enter straight to the table. Any help would be great
 
You'd have to be more clear in your explanation in order to get help.
 
Ok my form has multiple fields when a user like memory stick they put the s/n in that field now it is in the table under there name. But if they have keys they have let say 10 how or what would be the best way to enter them in on this form. I tried a combo box list box a field nothing i would like there to be a list box that shows the keys. But the problem is getting that info from the form to the table.
 
Ok my form has multiple fields when a user like memory stick they put the s/n in that field now it is in the table under there name.

I still have no idea what you're talking about. Your multiple fields, are they bound or unbound? What does a memory stick have to do with this? What's an s/n?

You're unlikely to get significant help if you can't clearly communicate your situation/problem.
 
bound its a inventory db so one of the fields in memory stick so the user would put the serial number in that field. The problem is the keys there is multiple
 
Im trying to send the db so you can see
 
Last edited:
I stripped it down no pics or some files but when you click inventory I need a easy way to add keys
 

Users who are viewing this thread

Back
Top Bottom