Will arrays work in MSAccess to facilitate population of one single field with many v

[DLeav57]

I would like to create one holding field to house which applications (Multiple) are relavant for each record.

Application 1
Application 2
Application 3
...
Application 25

Records Application(s)
Record 1 (App1, App3, App17)
Record 2 (App3, App4, App5)
Record 3 (App9)
Record 4 (App10, App,16, App25)

Also, is it possible for user to see list to select from prior to choosing?

Thanks in advance,
Dan

[DLeav57]

Never mind, ... I just found my answer:
There is an 'ALLOW MULTIPLE VALUES' checkbox under the Look Up Wizard which works great.

[Rabbit]

Your data is unnormalized. This will result in more difficulties later on. You may want to think about taking a little extra time to normalize your data now rather than dealing with the headache that will result down the line. We have an article regarding normalization here: http://bytes.com/topic/access/insigh...ble-structures.

[DLeav57]

Thanks Rabbit.

The LookUp is coming from a distinct table so it should already be normalized. I will read the article on your link to see if I am missing something.

[Rabbit]

Because you have multiple applications per row, that makes it unnormalized.

[DLeav57]

Okay, I see the confusion ...

I tried to place a rather generic term to illustrate what I needed. I was referring to sources of data for each specific query I was building. My data is coming from one database, with many MUMPS globals: INPATIENT Pharmacy, OUTPATIENT Pharmacy, IV Pharmacy, LAB, et cetera. (I referred to those as applications).

I am creating a database to help me catalogue several queries (each as an individual record.)

The queries may trancend many Mumps Globals to get the desired output. I am listing each inner joined global (application) associated with the queries output for each query. So, duplication is expected.

This will just be a roladex to utilize MS Acces to look up which queries are associated with which package global.

I fear my explanation may have created more confusion ... but I believe I am okay.

Thanks