Results 1 to 4 of 4
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Lookups Vs. Relationships

    I was told that using Lookup fields in tables is not a good Idea or proper database setup/Management.
    already having had problems using the Lookups in tables I want to understand more how not to use lookups in with related fields in tables




    So How do I set up the relation in the tables

    If i have a list of accounts in a table, every account has AccountID and AccountName

    and in my table of transactions, every transaction has an Account name, so is that linked field AccountID and that field is just a data type number, Long Integer?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Lookups are good.
    You only need the relationship for ownership, like Client table owns Expenses, payments.

    or shopping cart: tOrder table has relation to tOrderDetails (all the purchases)
    it does NOT need relation to tProducts. The product is added (as lookup) to the tOrderDetails ,to add the ProdNum & Price.

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    Oh I don't have anything that complicated

    I just have people (chapters) paying dues in

    and then making payments out for storage, fuel reimbursements, venue fees for meetings, etc.

    want to be able to track how much is spent for different categories, and track dues payed in by chapters.

    Sometimes we will Loan a chapter money, then will need to track the payments back in.

    But I think/Hope I can do this all with one table of transactions, then i should be able to get any information I need using query's

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    tClients tbl(master)

    tPayments tbl (child)
    PayID (autonum)
    ClientID (long)
    PayDate
    AmtPd
    PayItem (storage,fuel,venue fee)
    PaidBy (check,cash,CC)
    etc...

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

Similar Threads

  1. autofill off of lookups
    By npi2017 in forum Access
    Replies: 2
    Last Post: 10-24-2017, 02:52 PM
  2. Multiple Lookups
    By datamonkey in forum Access
    Replies: 5
    Last Post: 05-12-2016, 09:52 AM
  3. Need Guidance On 2 Table Designs, Relationships & Lookups
    By tdelios in forum Database Design
    Replies: 2
    Last Post: 05-31-2015, 04:27 PM
  4. Problem with lookups
    By Beachbum in forum Database Design
    Replies: 1
    Last Post: 02-01-2012, 12:22 AM
  5. No Lookups in a Table
    By oleBucky in forum Database Design
    Replies: 9
    Last Post: 03-23-2011, 01:40 PM

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