Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2011
    Posts
    8

    Two tables with same table lookup

    I'm working on a staff database right now and I have two tables - one to capture staff's particulars (tblstaff) and one to capture his dependents' particulars (tbldep). In both tables I want to record their nationality. I have a nationality table which I plan to use as a lookup (tblunat).

    Qn: can I use the same table lookup for both tblstaff and tbldep?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    assuming you are defining a table for nationalities then yes
    if you are using he abomination that is the 'lookup wizard' in Access then no.
    design it as a table with a foreign key from staff and dependants pointing to the nationalities TABLE
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Posts
    8

    Like this?

    Is it to be done like this?
    Attached Thumbnails Attached Thumbnails image.jpg  

  4. #4
    Join Date
    Oct 2011
    Posts
    8
    Anyone can confirm if I'm setting this up correctly?

Posting Permissions

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