multiple entry in a particular field

  • Thread starter Thread starter R Subrahmanian
  • Start date Start date
R

R Subrahmanian

I am designing a table and data entry format for some
customer information. One or two fields (like credit card
number, email ID) may have one record or more than one
record, optionally. Is it possible to design the table and
data entry form with a single field for this, but accept
more than one entry for some of the records only. If not,
can you kindly suggest an alternative solution. Thanks.
R. Subrahmanian
 
The proper approach is to have a second table, linked to your first table,
and store the multiple values as multiple rows in the second table.

For each, if your Customer table has CustID as its primary key, you'd add a
table CustomerEMail, with the primary key of CustomerEMail being both CustID
and EMailID (where EMailID is simply a field that holds 1, 2, 3 to represent
the number for each e-mail addresses)

A common approach is to have a subform that links the two tables.
 
Back
Top