List

[smash54]

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

 

[Adam Caramon]

You'd have to be more clear in your explanation in order to get help.

 

[smash54]

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.

 

[Adam Caramon]

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.

 

[smash54]

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

 

[smash54]

Im trying to send the db so you can see

 

[smash54]

I stripped it down no pics or some files but when you click inventory I need a easy way to add keys