multiple entries in single field

[scott pajari]

how can you multiple entries in a single field. example in a disaster
recovery database I want to list computers with multiple applications
and their corresponding product keys in a single box or field

 

[Guest]

Use a Memo type field. Break each line in the field with
Ctrl+Enter. The field is fully searchable later on if
you're looking for particular text randomly entered in any
particular record.

Hope this helps.

 

[Rick Brandt]

how can you multiple entries in a single field. example in a disaster
recovery database I want to list computers with multiple applications
and their corresponding product keys in a single box or field

Fields should never have more than one piece of data in them. You need a
second table that is related to the first with a 1 to many relationship.
This is the why they call them relational databases

Then you can use a form/subform to enter the data.

 

[Van T. Dinh]

I agree with Rick but I think in terms of Many-to-Many
Relation. With the M-to-M relationship, you will need at
least 3 Tables:

* tblComputer ComputerID PK
* tblApplication ApplicationID PK
* tblCoputerApplication that joins Records from the above
2 Tables.

Check Access Help on Many-to-Many relationship.

HTH
Van T. Dinh
MVP (Access)