Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







How To Relate Tables And Display The Correct Values..


I'm sorry if this is obvious, but I have asked local professionals and scoured this site for answers before posting...

I have a database that I'm using to store and analyze language samples (basically, the mistakes that students make when trying to speak in another language). For each bit of language, I want to be able to say what domain the mistake belongs to - e.g. the 'clause', 'phrase', or 'word' domain. I have a table containing the five domains. I also have a table for each of these domains, containing the specific types of mistakes relevant to that domain. It is conceivable, but unlikely, that I will ever add to the domain table, but highly likely that I will add types of mistakes in the five related tables.

As I analyze bits of language, I will be appending each analysis (record) to a table as shown in the attached image. So far so good. The part that I cannot fathom, though, is how to display (let alone perform calculations on) this data: While the ErrorDomainID is a foreign key to the ErrorDomain table, the ErrorUnitID could refer to one of five tables, so that an ErrorUnitID of 2, for example, could refer to one thing if the Domain is 1 but quite another if the domain is 1 or 5 or whatever.

I've tried all kinds of coding and SQL workarounds, but I have a feeling I'm just missing something very basic here. If anyone could offer some guidance, I'd be extremely grateful!

James


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Help ! Display Values From Tables!
Hi guys,
I need urgent help on a simple question. I hope you will be able to help me.
I have a table CustomerMaster which stores customer number and name. (Customermaster)
I have another table which stores the product details for customer. (customerProduct)
I have another table which shall store order details. (CustomerOrders)
On the form, the user selects a customernumber, the system then displays the customer name.
The user then picks up the product ordered by customer (picked from combo box). On the combobox on recordsource I have given a select query which fetches the records matching the customer selected from table
Now I want the Product Price, tax and duty of the product to be displayed for the selected product. Somehow, I have to again make that as a combobox and then select the price (although there is only one record...
Can anyone tell me how to do this?
Regards
K

View Replies !   View Related
Help ! Display Values From Tables!
Hi guys,
I need urgent help on a simple question. I hope you will be able to help me.
I have a table CustomerMaster which stores customer number and name. (Customermaster)
I have another table which stores the product details for customer. (customerProduct)
I have another table which shall store order details. (CustomerOrders)
On the form, the user selects a customernumber, the system then displays the customer name.
The user then picks up the product ordered by customer (picked from combo box). On the combobox on recordsource I have given a select query which fetches the records matching the customer selected from table
Now I want the Product Price, tax and duty of the product to be displayed for the selected product. Somehow, I have to again make that as a combobox and then select the price (although there is only one record...
Can anyone tell me how to do this?
Regards
K

View Replies !   View Related
Relate 2 Tables
I am trying to figure out create a new table from two other tables. It is a tax document and one has a pin field that is unique and the other the pin field is not unique. So in the table the that doesn't have a unique pin field, the pins occur multiple times for all the different tax enitites people pay to. I need figure out how to make one table that combines these too. I have tried using the relationshop function but i am not sure if this is what i need to do and i am not that familiar with access. If there is anyone that can help me please let me know. or if you need any more information.


Thanks
Justin
Mclean county regional planning commission

View Replies !   View Related
Trying Too Relate Data Between Two Tables
I am using Access 2003.

I am creating a subform [Billing]! that is intended for collecting billing information. I have the [Start] and [Stop] times for appointments calculated to provide the amount of [minutes]. I than need these minutes converted to billable units.

[Stop] – [Start] = [Minutes] need to arrive at [units]

I am attempting to do this by:

I created a table [Patient Billing]! that contains fields for [billable minutes] and [units] – creating the relationship.

I would like to be able to use that table [Patient Billing]! To calculate the units billed that appear on the [Billing]! subform.

How do I accomplish this comparison between minutes in to tables to arrive at the units amount?

View Replies !   View Related
Display Form Correct With Different Resolutions
One of my probs with access is changing the form when a different resolution is being set.
Is there a visual basic module or something else to display the form properly dependent of the selected resolution?

View Replies !   View Related
5 Parameters But Not Getting The Correct Results When Values Are Nulls
I have a question I hope someone can help me
I have 5 parameter query that gets its value from 5 combo boxes from a form

The
following function is in the criteria grid for one of the fields:

Like NZ([forms]![searchform]![combo69],"*")

when I enter data for a combo box for one of the combo boxes then if there is a null value in another one of the parameters combo boxes then it does not show. so I tried this:

Like NZ([forms]![reports_switch_main]![combo70],"*") or is null



but then when i run the form and i put an value in one of the combo boxes if there is a null value in the results it shows also, i don't want that. My form has 10 columns in which some have data and some dont for all rows


is there any way to do this? help!

View Replies !   View Related
How To "Relate" Tables
Hi I have read quite a few posts and googled loads after advice fron some of the forum users and am still confused (which is not hard :confused: )

I am in the process of designing a new database to keep records for patients (medical type!)

At the moment I am designing the tables and am somewhat confused as to how I would link these in the future?

The tables I will have are

Patient Details (First Name, Last Name, Date Of Birth, Address etc...)
Treatment Table (various fields relating to a treatment)
Consuambles used Table (induvidual items used to treat a patient and the quantities used, bandages plasters medications ect)
Vaccination Table (Various field relating to vaccinations)
Accident Report Form Table (various fields relating to a treatment that was need because of an accident)


What I hope to be able to do in the end is to "pull" up a form / report that will show all the treatments and consumables used for that treatment, Vaccinations and accidents a particular patient has had?

I really would appriciate any help anyone can give me on this but more so if they could explain it very basically

Cheers guys

View Replies !   View Related
Display Only Positive Values In My Query
Hi.. I am a beginner using access and there is probably an easy solution for this which i dont know about!

I have made a query where i calculate the tax deductions for a payroll system. my problem is that different workers are to be taxed differently given maritial status and number of kids as well as net income.

I have managed to calculate everything with the kids and wifes but now i need to sort the table after how much they earn to deduct taxes. I have a "first stage NetPay field" now, where i can see the Gross pay minus allowances for wifes and kids.

Now, if that value(first stage netpay) is under 8840 no more deductions are to occur. If the value is between 8840 and 10000 i have to deduct 15% of the excess above 8840

If the value is between 10000 and 20000 i have to deduct a further 174+ 25% of excess over 10000

If the value is above 20000 i have to deduct 2674+ 31% of excess over 20000


So far what i have done is make a new coloumn, where i take "first stage netpay field" and subtract 8840. If the value is negative i thought i could show only the positive values by enterin >0 in the criteria field for the query, this however will make no posts show up..

(I tried entering Abs() in the Field coloumn where i made the expression, and this worked. )


So my question is: is there a function like Abs() i could use that would convert negative values into 0?

Or do any of you guys have a better idea of how to solve this?




Hope someone can help me...


Takstein

View Replies !   View Related
Combo Box Values Display Slowly
My Combo Box is tied to a table with many entries. When I click on it to display the table values it takes several seconds to display. Is there any way I can "pre-load" the Combo Box (such as on form load, etc.) so when I click on it it displays more quickly? Or is there another way to speed it up?

Thanks ...


View Replies !   View Related
Relate Chart To Search Form On The Fly
Hi,

I'm having problems relating a pivotchart with search criteria automatically after the search - all on the same form. This will be a nifty trick if it is possible, and I can imagine other uses for a form like this.

Without being overly wordy, I attach a mdb in hopes that someone with a bit more skill than I will take an interest and set me on the right track.

View Replies !   View Related
Relate List Of Colours To Unique Product Id
Hi.

I want to select a product then be able to select a colour from a list that relates to it.

I want the colour lists to be different for every product. (clothes)

Whats the best way to do it?

Thanks

Jonny

View Replies !   View Related
Problewith Relate Betwen Table And Form
Hello I.m new and thankyou for designer this forum
I have this question :
i made a Table and made a Form from Designer Form
and put a textbox on it , so how to show the data in the text and sva it in the table or by another way how to relate betwen the textbox and table
and thankyou for help

View Replies !   View Related
Populating The Text Box’s That Relate To The Chosen Combo Box’s With The Sum Of A Cal
Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful

Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation.

In other words if X combo box is chosen (There are many combo boxes to choose from) populate xx text box with the sum of a calculation.

Refer to the print screen example of my program: http://www.roofmart.net/Rest.asp

Notice under the label felts the 15lb 36” felt combo box is chosen and it displays the value of 11 and next to the combo box is a text box that displays the value of 25 The calculation will be (11*25) = 275 this value of 275 must be added to the text box values that are being shown in the forms header under 30yr where it reads $4,606.80 and 40 yr $6002.80 only, this is because the 30yr comp and the 40 yr comp combo boxes are the only chosen roof types under the label roof types above the felt label.
Hopefully this makes sense.
Thanks -- Any help with be greatly appreciated.

View Replies !   View Related
How To Display OLE Images In Forms From Tables
I've got a form about personal attendance list (table: ATTENDANCE) where I need show their photos (these OLE images are save in another table PERSONAL)

How I can show photos in the attendance form ?
Thanks

View Replies !   View Related
Display Data From Two Tables In Query
I have a database which contains details of groups of students. Groups are assigned tutor(s) using a link table between the Groups table and a Tutors Table.

I want to create a query which shows each group with their tutor. If I add the three tables to the query I can correctly generate a list of groups with their tutors, but any group which hasn't got a tutor (i.e. where the Tutor column would be blank) doesn't feature in the results.

I want all groups to be listed, even if they haven't got a tutor. Is this possible? How?!

Thanks in advance,

Gary

View Replies !   View Related
Query 2 Tables, But Only Display Fields From One Table
I have two tables:

Employee
TokenID (PK)
name
location
post
..
..etc


Rating
TokenID (PFK)
FinalScore

I am trying to display all the fields from Employee table where Employee.TokenID= Rating.TokenID but I only want to display the fields from the Employee Table and not from the rating table. And each record displayed should be distinct by the TokenID....

View Replies !   View Related
How To Display Field Types Of Access Tables In Vba?
How to display field types of access tables in vba?
can any one show me how i can display display field types(like : phone integer ....) of
access tables in a text box using vba? I have no idea how i
can obtain that information using vba. Looking forward to your
replys.Thanks

View Replies !   View Related
Continuous Form - How To Display Info From Tables With One To Many Relationships
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 Replies !   View Related
QRY To Get Values From 2 Tables
Hi all....

I have been beating my head for 2 days on this. Any help will be GREAT!
I have 2 tables: CLIENTS and RELATION

NAMES has the client_ID, first_name and last_name along with other information for clients. RELATION is how the clients fit with each other. RELATION has relation_ID, Relations_description and up to three fields where we can enter the ID of clients from the client table called Rel1_ID, Rel2_ID, and Red3_ID. Now all the three rel_IDs come from CLIENTS and stores only the client_ID. There are multiple relationships.

How can I display the names and not the IDs for the clients?

I am able to display only one client name. I need this for form as well as report. I can do dlookup for form but don't know for reports. I am thinking that if I have it in the query, then I can use that for the form as well as reports.

I am able to show the the name for one client by running the following qry. But I am not able to modify that to show the other 2 names.

SELECT RELATION.Team_Name, RELATION.relations_Description, RELATION.rel1_ID, RELATION.rel2_ID, RELATION.rel3_ID], [client.f_name] & " " & [Client.l_name] AS Client_Name
FROM RELATION, CLIENTS
WHERE ((([relation.rel1_id])=[client.client_id]));

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved