Linking Info From 2 Tables To Same Form By A Field

Jan 25, 2007

I have two Tables, Contacts and FlowMeters.

On the Flow Meter Form Info is listed specifically for each Flow Meter.

I would like to bring some of the information from the Contacts table on this form.

For Instance if I am on Meter 1T-02 I would like for it to associate that meter number with the name of the customer thats already on the form, then look up that customer's name in the contact table and bring over that customer's contact information.

I built this database over a year ago and it has been a long time since I have worked with the design of it, therefore I am a bit rusty.

Please help if you can.

Thank You

View Replies


ADVERTISEMENT

Updating Field Info Between Two Tables

Aug 19, 2015

My father tables contains all the relevant fields with info of my products (which are listed in records/rows). My sister table contains less fields but are all present in the father table. The info is imported from excel daily into the sister table - all the fields here change regularly except for the unique ID which is present in both tables. Because the sister tables' information for the records/rows changes, it is difficult to update the selected fields of the father table.

I want to update selected fields within my father table based on the information I upload from the excel sheet (which becomes the sister table when uploaded)

View 1 Replies View Related

Tables :: Linking Multiple Field Values To A Field Selected From Combo Box

Feb 16, 2014

I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)

Tables:
* Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player)
* Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box)
* Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box
* Venue - similar to Competition table
* Opponent - Similar to above two tables
* Match - MatchID, Competition, Venue, etc (form corresponding to table attached)

Forms:
* Player form
* Match form

Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).

View 1 Replies View Related

Tables :: Linking Field Data Between Tables And Within Tables

Sep 26, 2012

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.

View 2 Replies View Related

Form Getting Info From Two Tables...

Jun 7, 2006

************** edit: Fixed!!!! *************


The database I'm working on is coming on nicely, thanks to some valuable help from this forum. But I've got a couple of new problems that I just can't seem to get my head around. Really hope someone out there can help!

So...

I have two tables (well, there are more.. but there are two main ones with the important data on them). The first is a list of Customers (you know, the usual Name, contact, telephone etc...). The second is a list of jobs for each customer.

After starting from scratch, I created a nice looking form wth control tabs that on one page shows you the customer information and on the second; the job history for that customer. I then have a third tab which lets you add new jobs. So I'm all chuffed because that is the basics of what I wanted it to do.

However, I need a hard copy of the job report to print out and give to an engineer to fill in or to print in future should a customer wish to see it.

Try as I might, the reports function didn't look as if it was something that could be "designed" the way I wanted it to look. So, I figured another form was in order.

I started by building a query which included all the fields from the two tables mentioned above in it; I.e. So it would pull up a Job Printout by a workorderID number. That way it would show all the company info PLUS the detail of that one particular job.

Problem is this: I can see from the query in table view that the Jobs are listed; but alongside them is a straight listing for all the companies in the database. Basically, the Company who received the job in question is not being shown by the query.... if you follow me. (Apologies if I'm explaining this like a fool).

Question 1 then... is how do I fix this? Is this something to do with these arcane relationships things?

Question 2: How do I create a button to print that one "form" by workorder ID.

Question 3: Did I do the right thing by using a "form" or is there a better way to create a "report" for printing that can be formatted the way I want (with logos and stuff)

Thanks again peeps!

View 3 Replies View Related

Tables :: Linking To Field In Another Table?

Jul 25, 2014

Is it possible to create a table and create a field that links to field in another table?

View 11 Replies View Related

Tables :: Linking Field To A Folder Of Information

Dec 18, 2013

I have an historical database table that contains information relating to soldiers. Additionally I have many photographs, and other documents appertaining to these individual soldiers stored in folders on my PC hard drive and I would like ideally, to be able to have a link from my database to these other items, so that when I open a a soldiers record I am able to click on a link that will take me to a folder containing the photographs, letters and further documents relating to him.

However this is where I am at a loss as to how to proceed, and how I could have this facility, I run Access 2007 by the way.

View 4 Replies View Related

Continuous Form - How To Display Info From Tables With One To Many Relationships

Apr 25, 2006

Hi everyone,
I've tried several different things to get around this problem and have found out a lot about what won't work!

Basically I am building a HR database. The main table is M_CandidateDetails and the primary key is CandidateID. This is a foreign key in all of the other tables: MCandidateEducation, MCandidateEquipExp, MCandidateSector. (I've attached a screenshot of the relationships.)

Goal:
What I want to do is create a continuous form with one record for each candidate. A record will show all of the info pertaining to a candidate. The form is to be used to for searching and filtering candidates.

Attempts..
First I tried creating a query to combine all of the information. (I've attached a screenshot of the query). The only problem with that was if joe bloggs had worked in 3 different industry sectors there would be 3 records for him. (I did have problems with the query not being updatable - solved that though by using the Dynaset property of the form)

Next I tried basing the form only on the M_Candidates table and using listboxes to display the information from the many-side of the various tables. But that didn't work as you cannot use an unbound control on a continuous form.

Then I tried putting in subforms instead of listboxes but you can't use subforms on a continuous form.

I'm out of ideas now- can anyone give any tips?

View 5 Replies View Related

Tables :: Converting Form Into Table - Where To Keep Previous Info After Update

Apr 24, 2013

I have a form that I need to turn into a table. The table will be updated each day with new information but I dont know what to do to keep the previous days info. I have attached the form ....

View 3 Replies View Related

Linking Tables With Form

Jan 4, 2008

I am having 4 tables where i enter all the data required. The tables are Project Details, Process Detail, Installation Detail & Cable Details.
Project Detail Table contains:Project Number,Project Code,wBS Code etc...
Process Detail Table Contains : Tag Number, Description, Service, Process values etc...
INstallation Details Table contains : Installaion Item, (nearly 40 items which are commonly used)
Cable Details Table Contains : Cable Number, Type of Cable, Size of Cable and so on
Now I need the form: Process detail containing the information which had been entered in Project detail also. Such as the Project Number, Code etc to appear in the form ( Just to display it)
In Cable Detail and INstallation forms I need some specific fields which are in Project details (project Number, Code..), Process Details ( The tag numbers, Description etc..) to appear as display.
The tag number shall be the primary key which shall be used in all forms except Project detail form. The information in Project details is just to appear in the report.
I could very well do it when all this information was in one table. As a beginer i am unable to solve this. So please guide me.

View 1 Replies View Related

Linking Up More Than 2 Tables In A Form

Mar 16, 2015

Linking more than 2 tables together in a form. I have Clients who from time to time go to the hospital. I want to keep track of my Clients hospital visits so I set up 3 tables. One for Clients, one for the Hospitals and one for Patient Information. An example of the tables looks like this (this is a short version):

Clients: ClientID - Autonumber
ClientFname - short text
ClientLname - short text

Hospitals: HospitalID - Autonumber
HospitalName - short text

PatientInfo: PatientInfoID - Autonumber
AdmissionDate - date/time
PatientNumber - short text

I figure that 3 tables are necessary because each client may go to more than one hospital and some or all may visit one hospital more than once. I have worked with junction tables before but not sure how to set up a form to capture the value of all 3 PK values and store them in one junction table.

View 14 Replies View Related

Autofilling Info From Table To Form Field

Jan 25, 2012

I'm VERY new to MS Access 2010 - in fact, I used some online youtube videos to get me started with the database I'm currently working on.

Here's what I have so far: 2 tables, one for customer information (name, phone, addy, etc) and one for invoices (inv #, customer ID (which should be the same as my primary key from the customer info table), phone, services rendered, etc etc)

I'm currently working on a form for Invoices, where I can simply put in the customer's name, date, cost, etc without having to look up the ID# and phone number for every time I use it.

View 1 Replies View Related

Linking Access Tables/form

May 31, 2005

I have a form in a DB and I would like to make it work so that when a user user chooses a job department (choice of 10). When they choose the department I want the next field on the form to only show the job classifacations(5 in each department so 50 if all show) in that department. Right now all I can do in make it so they need to choose from many job classifacations (50 of them as explained above where 45 have nothing to do with the department first choosen) and most of them don't relate to that department at all. Is it possible to do? I have limited macro knowledge and no code ability.

Thanks

View 2 Replies View Related

Forms :: Linking Several Tables On Tabbed Form?

Oct 6, 2013

I want to have a navigation Form where the top tab will show the main Customer, and in the same tab also a sub table with chosen contact information.

With that top tab chosen, I want to chose left tab wich shall open (in this example) the phone number of that contact.

I provide a PDF with a few pictures of tables, relationships and how I want the forms to look.

View 5 Replies View Related

Forms :: Linking Multiple Tables To A Form?

Aug 26, 2014

problem is that i have 2 tables - Consolidated Orders, Customers.

Customers has 2 fields with a record inside one field with the clients name , but it also has an address in another field in the same table which i want to link to the name of the client because in my invoice i show the companies name and to the left of it i show their address.

i wish to link the two fields together so that when the name shows up, the address of the client will be to the left side .

View 2 Replies View Related

Linking A Field To A Unbound Form

Oct 16, 2006

i have a form "send mails" which is unbound
it have a combobox field "to" ,i want it to bound to a field "names" in the table "email"

View 5 Replies View Related

Forms :: Linking Field From Main Form To Subform

Aug 16, 2013

I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form.

PHP Code:

Me.lngSCode = DLookup("[lngSchoolCode]", "[qrReadingFirstSchools]", "[lngSchoolCode]='" & Me.cboGetCode & "'") 

This is working very well.Now, what I would like to do is get code as shown in the cboGetCode field to my sub form lngSCode field.

View 1 Replies View Related

Forms :: Linking Form Operations To Values In A Field

Sep 8, 2014

I have a combo box field called "investigations" on a patient database which can allow multiple values. Each of its values represent the different investigations a patient can do. Now those investigations are tables and forms in the database. how can i program the database to simultaneously open these forms "on update" of that field-investigations?

View 1 Replies View Related

Queries :: DSum - Update A Field In Specific Table With Info Form Another Table

Aug 5, 2014

I have a table products with a field "id_product" and "total" (Total items in stock)

I have a query with the fields "id_product" and also the field "total in stock"

I want an update query to update the field 'total' in table 'products' with infos from that query

For each id-product in table products, replace the field total with the field 'total in stock' from the query

So I want to update a filed in a specific table with infos form another table.

View 2 Replies View Related

Tables :: Two Identical Database - Importing Tables By Linking To Data Source

Dec 3, 2012

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?)

View 1 Replies View Related

Tables :: Linking Tables With No Common Data And Different Numbers Of Observations?

Apr 15, 2014

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 .

View 3 Replies View Related

Tables :: Linking 5 Tables As Unable To Exceed 255 Rows

Mar 18, 2013

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.

View 4 Replies View Related

Options To Get Info From Tables

May 16, 2005

It seems that there are a few different ways to get info from the tables when developing an applications that i know of:

1)queries
2)dao
3)ado
4)selects without any of the above

I lean towards the last 2 but I need to know this: is there any advantages in using ado as opposed just sql?

For instance i ran this sql:

Private Sub Command0_Click()

Dim SQL As String
Dim strCriteria As String

strCriteria = Forms![form2]![Text1]



SQL = "SELECT * FROM Table1 WHERE (((Table1.clinic)='" & strCriteria & "'))"


DoCmd.OpenForm "frmClinic"
Forms![frmClinic].RecordSource = SQL
End Sub

it worked fine. I could see how a beginner would prefer to use queries over sql but I would prefer to use sql in vba. I've read that dao is older and I should use ado instead. So that leaves ado vs. the way I displayed it in the above code. So which way should I go? If I'm over looking queries or dao in favour of ado/sql, just point out their advantages if you don't mind.

Thanks,

scratch

View 4 Replies View Related

Pulling Info From Tables

Nov 8, 2004

I am trying to get an email address from a table by choosing a employee number from a combo box...it is almost working,
however, it is returning the employee number as opposed to the email address...here is the code I am trying to use:

Private Sub Combo0_AfterUpdate()

Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = myConnection
Dim mySQL As String

mySQL = "SELECT EmailName .*,[Employees] FROM EmployeeNumber"

myRecordSet.Open mySQL, , adOpenStatic, adLockOptimistic

myRecordSet.MoveFirst
myRecordSet.MoveNext
myRecordSet.Close

Set myRecordSet = Nothing
Set myConnection = Nothing

End Sub


Then, in the section for the command button and the Outlook code, I have:

eMailAddress = Me![Combo0].Value


like I said, it is returning the same value that is in the combo box...if anyone could help, it would be greatly appreciated

View 1 Replies View Related

Getting Info From 2 Tables To One Report

Sep 29, 2007

I'm a genealogy nut and not so great at computers. I've got a report on cemeteries that gets things like a cemetery number, peoples names and tombstone information from one table. Got that working pretty well. I've got it to print the cemetery number in the detail header (there are 300+ cemeteries each with 1-100s of people in each). I want to take that number and use it in a different table to get travel directions and GPS for each cemetery.

View 3 Replies View Related

Creating Two Tables And Having Them Get Info From Each Other

Apr 2, 2012

I am very new to access and I am trying to create two tables called Customers and Orders.

The fields in Customers are:
CustomerID (Primary Key), First Name, Last Name, Address.

The fields in Orders are:
Order# (Primary Key), CustomerID, Product Purchased, Address.

There is a One to many relationship between CustomerID in the table Customers, to the CustomerID in Orders.

The problem I am having now is with the Address field.

GOAL: What I am trying to do is have the Orders table automatically get the Address from the Customers Table.

If that doesnt make sense, whenever I create a new Order, I want to enter the customerID, and have it get the Address data from the Customers table automatically put into the proper field in the Orders table.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved