Results 1 to 4 of 4
  1. #1
    bishop0071 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    24

    Adding same data to different field within another table.

    I have tblCategory and tblExercise. The data in tblExercise can sometimes match with more than one record in tbCategory. When inputting data into tblExercise how can I choose to have that stored under more than one field in tblCategory?

    Example:

    tblCategory: Arms
    tblExercise: TRX Biceps Curls

    so TRX Biceps Curls can also be under
    tblCategory: TRX

    Right now I have to input TRX Biceps Curls under Categories Arms and TRX. Very time consuming. I hope there is an easier method.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Data structure doesn't sound normalized. If you want to provide for analysis, follow instructions at bottom of my post.

    Why is this data entry time consuming, what is it for?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    bishop0071 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    24
    I can have for example, TRX Pushups. I can put that under Category Chest, TRX, or Core. So I would have to type in TRX Pushups in each one of those categories. Having it under those categories would help because if I wanted to look just for TRX exercises I can pull up TRX and it only shows me those exercises. Same goes for if I wanted just Chest exercises or Core exercises.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    What if you wanted to search for Pushups and find all the categories Pushups is associated with? Would be possible with your table but a little more complicated than with normalized structure.

    Normalized structure would be:

    tblExercisesCategories
    ExerciseID
    ExerciseCategory
    ExerciseName

    Regardless of structure, might speed up by using combobox to help populate fields. Combobox can have RowSource that is a static list or can have table source for the list items.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-28-2013, 07:00 PM
  2. Adding data from linked table to existing table???
    By claysea in forum Import/Export Data
    Replies: 3
    Last Post: 02-21-2013, 12:23 PM
  3. Adding a field to a table with vba-code
    By Mgomp in forum Programming
    Replies: 4
    Last Post: 03-12-2012, 07:58 AM
  4. Replies: 3
    Last Post: 12-19-2011, 11:18 AM
  5. Adding data to a table
    By Jbelle7435 in forum Programming
    Replies: 17
    Last Post: 06-13-2011, 07:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums