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

    Handling Fill-In Data with Tables

    For fill-in data, such as open-ended questions and addresses, I'm thinking no lookup table would be needed. Just link the main PK as an FK, as shown in the attached image?

    (I realize that I could also incorporate the address into my main table (in my case, tblClients), but it might be beneficial to track addresses and phone numbers over time...might not, but who knows--I'd rather have it just in case.)



    Click image for larger version. 

Name:	tblClientAddress.png 
Views:	10 
Size:	39.8 KB 
ID:	41060

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Should work OK.
    However, cacClientID_FK should be a number, long integer, to match the autonumber PK in tblClients.
    Last edited by davegri; 02-25-2020 at 11:15 PM. Reason: sp

  3. #3
    PrincessApril is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    42
    Oh yes forgot to change that whoops.

    by "ok" do you mean there is a better way? Just trying to structure the db as tightly as I can from the beginning.

  4. #4
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    by "ok" do you mean there is a better way? Just trying to structure the db as tightly as I can from the beginning.
    If you want to keep a history of addresses, or have multiple addresses for a client, this is the correct way.

  5. #5
    PrincessApril is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Feb 2020
    Posts
    42
    Ohh you just reminded me that sometimes multiple addresses are relevant, such as for a client who lives a bit far and spends time with a relative to access their services in the city more easily. I suppose this wouldn't come in handy too often (even then, there would be the current address, but if we lose contact and needed to find the other address for an emergency-contact situation, it might help to have a record of the old address--better safe than sorry I suppose)

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

Similar Threads

  1. Data handling
    By Erictsang in forum Access
    Replies: 1
    Last Post: 09-04-2017, 08:33 AM
  2. Replies: 2
    Last Post: 12-19-2016, 07:30 PM
  3. Auto fill Data number between tables
    By Parvinder in forum Access
    Replies: 1
    Last Post: 02-07-2014, 05:18 PM
  4. Auto fill data (number) between tables
    By juli in forum Access
    Replies: 1
    Last Post: 08-31-2011, 10:41 PM
  5. Replies: 0
    Last Post: 03-05-2009, 12:27 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