multiple entries in single field

S

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
 
G

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.
 
R

Rick Brandt

scott pajari said:
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
Click to expand...

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.
 
V

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)
 
Top