relationships

I am currently learning PowerPivot in hopes it can help our school manage student assessment and scheduling data. I have 2 main Tables uploaded to Power Pivot. In Table 1 I have the entire school schedule organized with the following design <tbody> Student ID Student Name Grade...

Ok, so I've spent the majority of this morning, and a good portion of last Friday looking through forum posts related to calculated fields. Here is where I'm having a problem: I have a claims database. My three main tables are: Claims, Payments, and Corrections. On Claims I have a field called...

Hi guys, So I've looked around online a bit and havent had any luck with this. I have a master table with Projects and SubProjects. Example: _______Table1________ Project SubProject Project 1 SubProject 1 Project 1 SubProject 2 Project 2 SubProject 3 I want to make other...

I've trawled the depths of Google (beyond page 20 of search results!) to try and find a solution to my current problem. Given that I haven't found a solution I'm tempted to believe that it's impossible but being an eternal optimist I've now decided to post something in here. Outline of what I...

Can someone help me please, I simply cannot work out why my PP relationship will not work as expected. I have two tables linked into power pivot. The first (table 1) is the Customer site ID and the Customer satisfaction data. Each site ID is unique. The second is a complete list of all site...

I've had success relating tables however I've attempted to create a table to compliment an existing table and draw the data in but the relationship fails. If anyone could explain why I'd appreciate it. I posted an example of the two tables below. I am trying to relate them between the...

I have two tables from my company's CRM--Accounts and Potentials. The Account table has a unique identifier (AccountID) that is 18 digits long which I am trying to use as the linking field in the relationship between the two tables. Because the AccountID is 18 digits, Excel turns it into...

I have a table, "Table A" created with basic data. I have another table, "Table B" that houses certain transactions done by Table A. However, I also need another table, "Table C", that houses a different set of transactions for the Table A data (I will actually have~4 tables of different...

Learning Access or know somebody that wants to? This lesson focuses on building Tables and Relationships in Microsoft Access. Learn Access -4- Tables and Relationships (cc) 36:04 (music: JD Live) Learn Access -4- Tables and Relationships (cc -- coming!) 36:04 ~music: JD Live - YouTube The...

Hi, I'm new to PowerPoint so forgive me if this is a basic question - my 'Learn PowerPivot' book is on the way! I am trying to establish a relationship between two tables. I have tried to post a picture but do not have permissions so I will try to explain. Table 1 is called ‘Raw’ Table 2...

I just installed PowerPivot, and am learning by going through the book 'PowerPivot For the Data Analyst'. I've really enjoyed the book, but I appear to missing some simple point. I have three tables. Each of the three tables have an ID. It's the same ID in all three tables. Table one...

Hi, I have multiple fact tables, and dimension tables. My question is : what is the best way to connect the fact tables together. At first I just connected each fact table to my dimensions. For basic calculation, that is working fine. But then I need to create conditions covering multiple fact...

Hi all, I have recently started using PowerPivot to analyze historical soccer results and so far I have been enjoying working with the tool. However, I have come across one obstacle that I can't seem to get past so I hope you are able to help me out. Currently my PowerPivot model has two...

I have two tables tbl_Transaction and tbl_SalesCall. Tbl_Transaction contains information on all transactions (Date, charges...). Tbl_SalesCall contains information on all sales calls (Date...). I want to make calculations such as the total charges in tbl_Transaction based on a date in...

I have a database with the main form titled "Orders" and a subform titled "Orders Subform". They are related through the OrderID on both forms. However, every time I add a new record to the subform it creates a new main form. I don't need 10 duplicate orders because someone ordered 10 items...

Hi folks, I have a simple website export of category names which are parent & childs of each other. They all reside in column "A". In column "B" & "C" I have the Category ID & Parent ID which is effectively a parent Category ID. "0" is the "Default Category" or master root if you like and what...

I can't get Access 2007 to create a one-to-many relationship. I have two tables. I drag the field from the one side to the table with the many side. Access opens the Edit Relationships window. The Relationship Type is Indeterminate. There does not seem to be ability to edit the relationship type.

I am relatively new to using Access and I have been asked to put together a database for allocating keys at our school. Every member of staff has certain keys allocated to them based on their role. There are also some keys which open multiple rooms. So for example a teacher will need a classroom...

We have looked at several mortgage software solutions for our company, but none have one essential ability that we need. We are currently running on a manual spreadsheet solution, and are wondering if we can automate certain aspects of it. We are a financier that lends out money to commercial...