Results 1 to 5 of 5
  1. #1
    PrincessApril is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    42

    Handling Yes/No Data with Foreign Keys

    Piggybacking on my previous thread, I'm wondering if we should handle yes/no data the same way as we would handle a lookup with multiple values? That is, instead of using a simple yes/no option in a table, would we use a lookup table, as shown in the attached images?



    (For context, the question for this table will be if the client is receiving medical case management services at another agency, with only a yes or no response being allowed for each assessment point.)

    Or, instead of doing it as in the attached images, would I use no lookup table and just have tblClientServicesElsewhere, with the third row being a yes/no data point rather than an FK ID lookup?


    Click image for larger version. 

Name:	tblClientServicesElsewhere.png 
Views:	7 
Size:	27.1 KB 
ID:	41057Click image for larger version. 

Name:	luServicesElsewhere.png 
Views:	7 
Size:	26.3 KB 
ID:	41058Click image for larger version. 

Name:	luServicesElsewhere(Data).png 
Views:	7 
Size:	19.3 KB 
ID:	41059

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    I've never seen a lookup table for a boolean. Not much point as it can only have 2 different values.

  3. #3
    PrincessApril is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    42
    Thank you davegri. So would the attached be a good approach, or would you handle this differently?

    Click image for larger version. 

Name:	tblClientServicesElsewhere_updated.jpg 
Views:	5 
Size:	62.7 KB 
ID:	41061

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Thank you davegri. So would the attached be a good approach, or would you handle this differently?
    Looks like a winner.

  5. #5
    PrincessApril is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    42
    Great, thank you for your quick replies.

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

Similar Threads

  1. Foreign keys
    By Accessuser67 in forum Access
    Replies: 1
    Last Post: 10-05-2015, 06:33 PM
  2. Extracting Foreign Keys
    By QuantifyRisk in forum Forms
    Replies: 7
    Last Post: 08-08-2014, 02:05 PM
  3. Query with Foreign Keys
    By BawdyB in forum Queries
    Replies: 5
    Last Post: 05-15-2013, 06:47 PM
  4. primary/foreign keys
    By st1300 in forum Database Design
    Replies: 38
    Last Post: 12-04-2011, 01:27 PM
  5. Need help with foreign keys
    By acdougla17 in forum Access
    Replies: 1
    Last Post: 09-26-2011, 03:50 PM

Tags for this Thread

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