Re: Access Tables

by Stephen Johnston <pepe(at)gainsay.com>

Date:	Thu, 23 Mar 2000 21:51:20 -0800
To:	Steve Segarra <ssegarra(at)mitre.org>, hwg-techniques(at)hwg.org
In-Reply-To:	mitre
	todo: View Thread, Original

Create another table for that.

Like this:

Person_ID       | Item_Checked_Out_ID
1                       123
1                       345
1                       678
2                       23445
2                       324234

Then you can select based on the person_id and get all the items that 
person has checked out.

-Stephen


At 01:52 PM 2/23/2000 , you wrote:
>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?
>
>Thanks,
>Steve

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