link tables

Hi, I'm still learning access and I'm having some trouble with a database I am trying to make. Below is a photo of the relationships I generated for the proposed invoicing system called Direct Pay Voucher ("DPV"). Here is the set up: Many employees can generate a DPV (we want to track who...

I have a Master table with essentially a database of about 1200 lines. To simplify for users, I want to link that Master table to other worksheets so I get the essentials, columns ABCDE etc, and can add new columns to the linked table. I've successfully used the Get External Data feature in...

I create worklist for my employees and they work on there worklist. I would like to create a master worklist that links to the other tables so when I update the table all of the work they have done on there table will appear on my table. I have tried a couple of different ways and can't seem...

Hello, I have this table that I currently use that's now grown to over 300 columns wide, and I want to split it up into two (and in the future, multiple) smaller tables. Basically, each record represents an account number, and the columns contain information about the account. I would like to...

I have an Access 2007 specifically for report-building using link tables. There's very little data in local tables, except for small tables used to filter reports, populate list boxes, etc. Right now, I'm trying to make a local copy of this db, including the reports, queries, forms, etc. from...

I am in the process of creating an Employee database, and have multiple levels of data, thus I split it to different tables. Table 1 - General information (Name, Birthdate, phone number and Address) Table 2 - HR information (Start Date, Employee type, Drivers License, SSN, Insurance) Table 3 -...