> I don't know if this is off-topic or not, forgive me if it is, but it is
> relative to web development...
>
>
> Is there a way in MS Access 97 to allow multiple entries in one field,
> ie.  We have barcoded items and I am designing a form for an employee to
> fill out when taking one of these items from a lab.  Now I need to have
> the table set up so that the user can take out multiple things at once,
> so he/she doesn't have to keep filling out forms.  And all of this is
> stored w/ a primary key automatically generated.  Now is it possible to
> have the table allow multiple entries into the barcode field, w/o
> declaring fields as barcode1,barcode2,...,barcodeN?  This way the table
> each primary key can handle an (in theory) infinite amount of items to
> be moved under it?

Steve...
I know a little of Access and although what you suggest is possible I must
ask why would you want to do it that way (that is if I understand the
question)

You would have tblitem storing the items  1, 2, 3, 4,   tbluser 1, 2, 3, etc
in another if it is only fairly small numbers you could get away with only
the two tables but to be most flexible you would add a third table
tblitemsout which could hold all the items out  The items could then be
checked in or out  via a subform on your main form.

If you need more contact me off list (as I would say this WOULD be off
topic)


Regards
Tom Keatley

• Web Designer Courses
• Off the Shelf Training Courses

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA