Results 1 to 2 of 2
  1. #1
    Paulobo is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    1

    Linking tables...should it be a lookup table?

    I have imported my existing customer list and would like to link it to a service call table. So I would like to select the customer and log a service call for that customer. If I do a one to many with customerbeing one and calls being many and enforce refr integrity it wants a record in customers. Also I have a rma table (return materials authorization) which might or might not be issued. So once again I have (maybe) many rma# for one customer and maybe one rma per call. How do I link these tables and do I enforce ref integrity?



    Thank you for your time and help

  2. #2
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Both the calls table and rma table need a foreign key pointing to a particular customer.
    You could have a main form with customers as its recordsource.
    In design view, on the main form, put a tab control. Drag the rma table to one tab and the calls table to the other.
    This puts everything on one form, nice and tidy.
    https://www.youtube.com/watch?v=NboJDp02zcw
    Last edited by davegri; 04-20-2018 at 09:23 PM. Reason: add link

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

Similar Threads

  1. Replies: 15
    Last Post: 03-23-2018, 09:53 AM
  2. Lookup Tables - how to use without linking in table design
    By grapevine in forum Database Design
    Replies: 15
    Last Post: 08-29-2017, 01:50 PM
  3. Replies: 4
    Last Post: 07-08-2014, 08:59 AM
  4. Replies: 6
    Last Post: 05-16-2012, 12:43 PM
  5. Linking a student table to multiple tables
    By iteachyou in forum Access
    Replies: 3
    Last Post: 02-06-2011, 05:53 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