Allow duplicate field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I have a field (fld2) that can have duplicate data so, I created autonumber as key field. But when duplicate data entered and tried to retrieve, only the first one shows. Is there a better way to design the database & tried to find "apple" both shows.

Thanks.

id fld2 fld3
1 apple from WA
2 pear from PA
3 apple from GA
 
Tables store data. Queries / forms / reports retrieve data.
What are you looking at when you see apple only once?




skk said:
Hi!

I have a field (fld2) that can have duplicate data so, I created
Click to expand...
autonumber as key field. But when duplicate data entered and tried to
retrieve, only the first one shows. Is there a better way to design the
database & tried to find "apple" both shows.
 
Hi!

I have a field (fld2) that can have duplicate data so, I created autonumber as key field. But when duplicate data entered and tried to retrieve, only the first one shows. Is there a better way to design the database & tried to find "apple" both shows.

Thanks.

id fld2 fld3
1 apple from WA
2 pear from PA
3 apple from GA
Click to expand...

Take a look at the bottom of your form. Does it show a toolbar with
arrow keys and "1 of 2"? If so, click the forward arrow key to see the
next apple.

Or, open the Form in design view and change its Default View property
from Single Form to Continuous to see multiple records onscreen
simultaneously. You may need to rearrange the controls on the form
(e.g. bring them all to the very top of the detail section and squeeze
the bottom of the section up to the bottom of the controls).
 
Back
Top