Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-15-2018, 11:17 AM   #1
Niranjeen
Newly Registered User
 
Join Date: Nov 2007
Posts: 17
Thanks: 3
Thanked 0 Times in 0 Posts
Niranjeen is on a distinguished road
Send a message via Skype™ to Niranjeen
Duplicate fields with unique values

I have a table with a set of fields that repeat in some record, and , other field have unique data on it.

I would like to find a way on the Forms to display(data entry locked) the Repeating data and list each of the unique data as separate textboxes.

Can somebody please help me find an easy way to solve this?

Table:
Data1 data2 data3 data4
Eats Fruits apples 101
Eats Fruits grapes 102
Eats Vegetables beans 111
Eats Vegetables peas 112
Drinks Cold orange 201
Drinks Cold soda 202
Drinks Hot coco 211
Drinks Hot tea 212


Thank you

Niranjeen is offline   Reply With Quote
Old 08-15-2018, 11:23 AM   #2
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,572
Thanks: 57
Thanked 1,874 Times in 1,824 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Duplicate fields with unique values

niranjeen,

Research database NORMALIZATION
See this link for more info.

Good luck with your project.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge Duplicate Values with a Unique ID accessca Queries 1 02-28-2014 08:56 AM
update query unique index contain duplicate values ss6857 Modules & VBA 0 12-15-2011 07:48 AM
Duplicate Values across unique records Klegg72 Tables 5 02-16-2011 01:32 AM
Initializing unique values for fields (Datasheet Form) jemartin80 Forms 13 01-12-2009 09:30 PM
Selecting duplicate fields from unique records in a single table dougmcc1 Queries 5 10-11-2004 08:16 AM




All times are GMT -8. The time now is 04:50 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World