Linking Columns In Two Tables?
Apr 19, 2007I have been able to link column A1 in Table A to Column B1 in Table B.
But I want to link Columns A2,A3,A4 to Columns in table B using A1 and B1 as the relationship. Can this be done??
Thanks
I have been able to link column A1 in Table A to Column B1 in Table B.
But I want to link Columns A2,A3,A4 to Columns in table B using A1 and B1 as the relationship. Can this be done??
Thanks
I am working with a large database of 8,000+ entries. We have five tables in this database, but mainly use three of them. The main table is "OAKE Main Table" which is basically a list of all members our organization has had. Each member has accounting data linked to their member ID number which has been generated by ACCESS, and can be accessed or edited by clicking on a sub table next to each member. The accounting data that has been manually entered in the OAKE Main Table can be found in the Accounting table.
Here's my issue. I need to be able to extract a list of transactions from this accounting table since January 1st. I can do this no problem, but all I get is the member ID and the accounting data. How do I get ACCESS to include the member ID's first and last name? or maybe even the first, last name, address, city, state, zip, etc so that I can get a list of people who have made donations, for example?
I'm assuming this will have something to do with the relationships we have set up in our table. Here's a picture of it. I have no clue how to make this work.
I have a database with two tables. tbl_job_information contains all the contracts info etc. tbl_data contains all the relevant work data. The first table is restricted to certain personnel, whereas anyone has access to the second table. Both tables have a column called 'job no', in the first table it is a primary key, in the second just a field. I would like to make it impossible in the second table to change the data in the 'job no' column to anything that is not in the same column in the first table. It this possible within the tables themselves, or would I have to do it via coding and forms?
View 4 Replies View RelatedCurrently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table is for invoices.
In my invoices table, I wish to link the column for client reference (note: stored in the Clients table) to the column that precedes it. This column will list the clients’ names and is selected from a drop down list that is linked to the Clients table.
What I want to do (if its possible) is to have the respective client ref. automatically show up in the next cell once I've selected the client to whom the invoice relates?
Am I making sense? Is that possible? If so, how do I do it?
Secondly, how do I do a sum of selected columns for my “totals” column? Basically, I want to add the figures found in several cells that precede it?
I have 2 identical database in terms of structure but it differs in data.
Basically I would like to import data from subDatabase to mainDatabase and ensuring that there are no duplicate records.
I have used the "link to datasource method" through importing the tables to have the "updating" function.
However, this method also means that the records in mainDatabase are also imported over to subDatabase which I do not want.
Is there a method to ensure that the records are shared/update one way only? (i.e. import from subDatabase to mainDatabase and not main to sub?)
Currently trying to build a database for customer management and order placement/tracking. Want to set a couple of rules so that if I for instance click yes of billing and shipping address the same that the database will automatically fill the shipping address with the data I inputted for the billing address in the same table.
The other issue I can see I'll run into is, I want to be able to select one of the company ID's (made up of a three letter abbreviation of the full company name) in the product ordering table and it will automatically fill in the rest of the customer data (phone, email, address etc) data into that form.
I am doing a project where we are collecting home owner data and information on all the dogs in the household. The data for homeowner has an autonumber primary key because no field is unique or has been consistently collected. I am struggling to link the data for the dogs to the owners because an autonumber primary key will not work since not all homes have dogs. I need to have this set up so that people who are not tech savvy can look up each homeowner (or dog) and get the dog (or home owner) information. And to make things even more fun we need up to 15 potential dogs per household each of whom will have 18 different pieces of data collected.
It looks a little like this (and you can see my not matching ID issue):
Homeowner table
ID First Name Last Name...........Total Dogs
1 Max Maximus 5
2 Min Minimus 0
3 Mus Musculus 1
Dogs 1-5 table
ID Date Dog 1 Name Dog 2 Name .......Dog 5 Name
1 (Max's) 4/11/14 Bobby Billy Betty
2 (Mus's) 4/11/14 Jojo
Min will have no dog records at all, just home information.how to link the dog's to the homeowners .
I have been asked to design a database to replace our old excel sheet to log one of our customers server builds. It a four noded system and i require a seperate log for each node serial models of parts etc, qa checks.
I intitial started by just using one table but forgot the limit was 255 rows, i need about 600 - 700. So my plan is now to transfer to indivial table for each node. Then, a general table named Main for all my other details.
Although this seems simple, i now have the annoying task of being able to link them all together and produce a single PDF file to send to our customer whilst only entering our system serial number once to produce this.
My basic understanding will be to create a System Serial Number field in each table a link it via relationships, but if i produce a report with everything i need would it input my details for all four nodes? If so how would i set this up?
I will be splitting the database once completed and then making a ACCDE file for my techs to use.
I recently imported an excel file into access. Let's say it contained data for both domestic and international customers. With different things needed from each type of customer, once in Access, it became needed and easier to create separate tables- one for international and one for domestic. However, each customer needs their own unique id - and I need a way to link or relate the tables in a manner that it will not allow duplicate customer numbers between the two tables.
View 7 Replies View RelatedI have two tables called Hardware and Desk. They both have two fields called ChangeID and Priority.
What I would like to do is set it so that if we change the Priority in a record existing/created in 'Hardware', the Priority of the related record in 'Desk', also changes.
How can I achieve this?
Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing.
Thanks
I am looking to lonk tables in a database.
I have one table a pc tables which has a list of pc's
the other table is a pc software table which has a list of software
i want to build a form to show the pc's and their software how do i do this
I have a table with job info like: job #, job name, job addy.
I would like my end query to look like this: job #, job name, job notes.
I want the query to list all jobs, job names, and job notes for a particular week(we have a weekly meeting on the status of our jobs), so if I were to query the jobs for 6/26, i would get: job #, job name, and job notes for that date as fields in my query.
I am not sure how to accomplish this. Should I make a seperate table that contains job notes? If so, how would I accomplish this and create a relationship between the job info table and the job notes table?
Thanks in advance!
:confused: How can I link a table to one specific item in another table in order to avoid repeating information? (ex: school name that would be narrowed down to its different departments)
View 3 Replies View RelatedExcuse me for sounding extremely dumb, but I have a question that is really bugging me. I have created a database using two tables. The two tables are called User and Assets. In both tables I have set the primary key to be the field Username. I have also linked these two fields.
I have created a form that is my interface for the database and can add and delete from the table (User). I now want to insert a sub form into my form, that displays the contents of my second table (Assets) and reference's the field Username. Hopefully this will enable me to display my table (User) in the Form, whilst only displaying the relevent data in the subform (Assets) for the particular user.
I'm sorry if this sounds confusing, but I would really appreciate your help ...
:confused: :confused: :confused:
Dear all,
I have a question which I think is probably very straight foward for those who know about these things. I have just created a new database, but there are obviously some problems with the design, because when I enter information into a form, I don't seem to be able to access the information through queries or reports.
I have 11 tables, and one single form (I created the tables, and then used the wizard to create the form). The main table is called 'Client Information,' and the key in that table is the CaseNumber. They key in every other table is called something along the lines of 'ClientDetailID,' 'IncidentDetailID,' etc. When I look at the relationships between the tables, the 'ID' field in each table is linked to the 'CaseNumber' field in the Client Information table. However, I don't have any fields actually duplicated between the tables. Do I need to do this? (ie, should I have the 'CaseNumber' field appear in each table, and then the 'ID' field from every other table appear in the 'ClientInformation' table?)
thanks so much, this is probably a really simple problem but I don't think I really understand the whole relationships and linking tables thing.
Hi,
I have tables in MS Access and the same tables in SQL Server.
I want to link the appropriate tables up so that when i update the table in MS Access, it will automatically update the table in SQL Server. I want to do this using an ODBC link.
Anyone with any suggestions of how to go about this?
Thanks
Hi I need some help linking some tables...
Does anyone knoe how i would go about taking several years of contact information and compine it all into one table
Thanks
Greetings,
I was wondering if you could advice.
I have 5 or 6 questionnaires and each of these is linked together by a person Identifier number. How can I do it so that all the questionnaires recognise that these tables are all linked by the same number.
Secondly, if I wanted to say, do a search on a particular number, is there a way to do that if i say, searched for that number in a query, i'd get all 5 questionnaires come up rather than have to do a search for each table (ie. one search brings all the results from all the tables up or at least a link to them
What would be great is if you could do it so that you could do a search on say, all who were a nationality and it brings you up all the results for all the different questionnaires.
Please advise,
thank you
Hi,
I have a 'main' database named(A), and I have 2 tables that I have linked from two other databases(B and C). NOTE: I kept all this 3 databases(A,B,C) in one folder named 'Joe' on my workstation.
Here is the issue, every so often when I open my 'main' database, and I need to query the tables in B or C(which I have already linked to in my main database), I get an error message saying something like "path to c:...B is not found." To fix this issue, I have to use the "Linked Tables Manager" tool to relink all the tables again. As you can this, this is causing me a lot of unnecessary wasted time. What will i have to do to have these tables linked permantely so that I don't have to relink everything?
Thank you.
Joe
I have four tables, the main one is like so:
table Person:
PersonID
Firstname
Address
Type ["Host", "Organizer", "Sponsor"]
the other 3 are like this:
table: Hosts
HostID
PersonID
table Organizers:
OrganizerID
PersonID
table Sponsors:
SponsorID
PersonID
Cash
Description
Each person can only be either a Host, Sponsor, or Organizer.
I have established the proper relationships in Access, but my problem is if i make a form to create Hosts say, it will create a person of type host, but it will not make an entry into the Hosts table linking the person's id. I presume this is because it doesn't know that the type field specifys which subclass the person is.
My question is how to get around this problem, can I somehow tell it that type indicates what other table to use, or can I manually insert them? (Since I have an individual form for each subclass)
I have these two small databases for work and they need to have tables linked. My problem is simple. When I have one of the DB's open I click FILE--> Get External Data --> Link Tables... then I double click the other database... all I get is a list of the tables in THIS (not the other) database!... the same thing happens if I want to IMPORT... it wont list the tables/Queries/Forms etc in the selected database on from the current database.
What's going on??
Help! Thanks so much guys
~Nick.
Two tables, Contacts and Jobs
Contacts fields, Contact number, Company Name, Last Name.
Jobs fields, Job number, Contact Number, Company Name, Last Name.
There are other fields, but they are not involved at this stage.
What I am trying to do is. On the Jobs table, select the Contact Number from the Contacts table and get the Company Name and Last Name automatically field in.
Anyone got any ideas?
Hi all
Can anyone tell me how to turn this code around, the code unlinks the tables on my db but i can't figure out how to reattach them.
Code:Private Sub cmdRemoveLinks_Click()On Error GoTo Err_handler DoCmd.Hourglass (True) Dim TableName As String Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset Set db = CurrentProject.Connection Dim dbs As Database Set dbs = CurrentDb() s = "quryUtlListingOfAllLinkedTables" Set rs = New ADODB.Recordsetrs.Open s, db, adOpenStatic, adLockReadOnly'add to the tableWith rs Do While Not .EOF TableName = .Fields("Name") dbs.Execute "DROP TABLE [" & TableName & "];" .MoveNext LoopEnd Withdbs.CloseSet rs = NothingSet db = NothingEnd Sub
Thanks in advance
In our company, passwords expire every 90 days (NO EXCEPTIONS) for DB2. This means that all my linked tables can't be accessed. There are many other users using the DB's and when I have to reset my password, I get locked out a lot because I can't seem to re-link the tables fast enough. It also seems that "refreshing" the tables from the Linked Table Manager doesn't work very well.
Is there an easier way??????
Every month for my construction company, I receive a pay application that consists of the following:
1) about 100 "Line Items" (each one being a different type of work performed)
2) a Subcontractor associated with each line item (a line item may have only 1 Sub, but a Sub may be listed multiple times for different line items)
3) Amount of work performed (in $$) on that line item by that particular Sub during that pay period.
My boss wants a db to track all of this info. She thinks the best way would to create a new table for each Pay Application, every month. Basically, we would be starting from scratch every month with a blank table. But, I think it would work better if the months were linked to each other in some way.
I could have a field called "Pay_App" and enter 1 or 2, etc. on every row for every line item every month. But, then each month, I would be entering a 1 (or whatever the month is) for every single line item and that seems stupid. I want to be able to pull up the entire pay schedule for a particular Sub (all of his payments throughout the entire job). Is there a way to link the different pay application tables once the data has been entered? Or is there an easier way to do this? I would appreciate any help that can be provided. Thanks.