+ Reply to Thread
Results 1 to 2 of 2

Assign table entries to other tables

  1. #1
    Registered User
    Join Date
    02-11-2011
    Location
    Vilnius, Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    Assign table entries to other tables

    Hello, this is simple and though question, but I know You can help me:

    I have an access DB and there are 3 tables. Master, John and Alisa.

    In the Master table I write entries by hand:

    ITEM DATE ASSIGN_TO
    Banana 2018/04/13 John
    Carrot 2018/04/15 Alisa
    and so on...

    So in another table - John - there is entry:

    ITEM DATE ASSIGN_TO
    Banana 2018/04/13 John

    In Alisa table there is:

    ITEM DATE ASSIGN_TO
    Carrot 2018/04/15 Alisa

    So I can assign entries to John and Alisa. John can see only items assigned to him and Alisa can see only items assigned to her. Both John and Alisa then can add more info to each entry, for example mark it as done.

    It is some variation of assigning info to people. And we all 3 can access this table at the same time and manipulate data.

    Is it possible and how to do that?

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Assign table entries to other tables

    Leaving aside normalisation, you want one table, then each person looks at a view of that table that is prefiltered to them. Not 3 tables

    It might be worth you having a read up on relational database design

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 23
    Last Post: 02-13-2018, 04:54 PM
  2. Assign a number to on the left row to unique entries on a list
    By Osanties in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-23-2017, 04:24 PM
  3. Replies: 1
    Last Post: 04-05-2016, 11:20 AM
  4. [SOLVED] Assign different named ranges based on variable number of entries
    By BrotherNeptune in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-17-2015, 10:15 AM
  5. Macro to create unique id from email address and assign to repeated entries
    By capson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2014, 11:26 PM
  6. [SOLVED] How Do I Assign Attributes to Entries Based on Category?
    By kelman17 in forum Excel General
    Replies: 6
    Last Post: 06-10-2013, 09:31 PM
  7. Assign names to tables
    By yonlet in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-07-2012, 02:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1