Issued Items Design Problem

[Stew]

Here is my current problem. I am trying to figure out a good way to make an issue item table, that shows who is issued what. However they can be issued up to 30 items. I am trying to avoid making a field in the issue item table for each item. I would like them to just be able to select an item from my item list, and a size, and then it would add that to the table. I can do this one item at a time, however I want to see if I can do this with only one entry per person on my issue item table without hard coding the items into a field list. I am trying to make this dynamic based on the first table. I explained this the best I could, if you don't understand it I am sorry.

[HansV]

You should *not* use one field per item, and you should *not* try to fit all items issued into one record.

You need a table structure like this:

x268.jpg

For data entry, use a form based on tblIssue, and a subform based on tblIssuedItems, or a multi-select list box.