table relationships

  1. E

    Relationships using multi-field compound keys setup & Possible Redundant Indexes setup

    Hello, So I have not built, managed, or even worked in a database for at least 3 years. I am building a Microsoft DB to do the following. Regularly, our company receives current/updated parts pricing & parts details lists from hundreds of different suppliers. Every time we receive these lists...
    • explrll
    • Thread
    • compound key compound primary field indexes primary key table relationships
    • Replies: 1
    • Forum: Microsoft Access
  2. E

    Building table out of parts of other tables in excel

    Hi to everyone I ve been reading https://www.mrexcel.com/forum/excel-questions/559828-combining-data-two-spreadsheets.html?highlight=excel+table+relations as i am trying to solve following Assume having two sheets in same work book. Sheet 1 contains table 1 with columns "Name" & "Group" Sheet 2...
    • excelakos
    • Thread
    • market multiple shets into one pivot table table relationships
    • Replies: 0
    • Forum: Excel Questions
  3. C

    indirect table relationship question

    Hello, I am just starting to learn about databases and MS Access. I have a question I have 6 tables tblBlanks, tblPowder, tblProcesses, tblTypes, tblColors, and tblProcessCategories tblTypes has a one to many relationship with tblBlanks through TypeID field. tblBlanks has a one to many...
    • Caylif
    • Thread
    • field ms access 2016 relationship table relationships tblpowder
    • Replies: 2
    • Forum: Microsoft Access
  4. M

    Access Relationship Assistance

    Hi, I am trying to figure out where to put the ChecklistItemInfo table (red border) in my relationships. I have tried it 15 different ways but can't quite seem to get it. See the image for the realationships that I quickly created in Visio. Please disregard the arrow from the Project table to...
  5. B

    Need help determining the number of data tables and their relationships.

    I am trying to track project activities and establish history for a sales and manufacturing process. We are a dealer and everything we do is pretty much custom-built. We do not maintain inventory. This database will not be used to monitor inventory levels, issue purchase orders, or generate...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top