table relationship

  1. S

    Issue: combining multiple workbooks with same table names

    I have a template (*.xltm) which has a few different tables in it, each table is named based upon what it is used for. Example: tblDates; tblLocations; tblStatus; etc A number of in-cell formulas reference the tables by name and their contents. When I save the file, it gives it a unique file...
  2. A

    Data Model Table Relationships

    I have a table that has a primary key that is common in several other tables. The "WBS" table has the primary key of "WBS Code" which is related to a WBS foreign key in many other tables (Estimates, commitments, Time Phased Data, progress, etc...) I having trouble getting the model to see the...
  3. 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...
  4. A

    Data Entry combo box not allowed to add record

    Ok - I have a main form with two subforms that pull fields from a single table (Details). On the Details table is a field called "ShippedToCustomer" which is linked to the Customer Lookup table (Lookup 1:many to Details). On the subforms, this is a combobox whose control source is...

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