Table Relating To Itself?

Apr 19, 2005

I have a table of guests that holds all of their details such as name; address; medical info; family background; etc. What i need to do is to hold on the database if they would like to share a room and if so, who with.

I thought it would be possible to lookup the names of guests in the same table but access tells me otherwise.

I thought about creating a linked table of my guests table but when I link person A to person B then person B is not linked to person A which I would like to be the case.

I thought about creating a table called tblShare to hold 2 names from tblGuest but im not to sure how I would make this work. I think I may have the same situation as above. If I go to person A and link them to person B would this show up on Person B? I'm not too sure.

I will try this out now. If anyone has any other suggestions or some guidence on this I would be very gratefull.

View Replies


ADVERTISEMENT

Relating A Table Back To PK

Aug 2, 2006

I am fiddling with a DB right now just to try to work out some table relationships. I have a PK, Name, it is accompanied by a year in school. I then want to relate the year in school in a different table with the requirements for that year.

such as

Year Requirement1 requirement2 requirement 3

these would be check boxes (yes/no), and I could accomplish it in this format, but I am trying to have a normalized DB so
I realize it should be like this

1st year requirement
1st year requirement
1st year requirement

but I do not know how to link this back to the PK name when switching it to this format, so that I can pull up a form that shows if the person has completed the requirements for the year they are in. I am I going about this wrong? I have been looking at normalizing DBs and relationships but can't figure out the logic for my DB thought.

Thanks for any help


Riley

View 1 Replies View Related

Tables :: Relating Two Records In One Table

Sep 22, 2014

I want to relate two records in one table, a parent child relationship. I can accomplish this task with two tables I realize. I'm wanting to write a database that will map a family tree. Internal to one table I want to be able to establish a series of relationships, parent-child, sibling, et cetra. Can this be done?

View 2 Replies View Related

Queries :: Return Description Value Relating To PO Table Value

Feb 10, 2014

I have 3 tables joined as attached and Im trying to use the PO from the PO_Detail table to display the Description from the Material_Req Table. The two values are linked as the description in the Material_Req Table is for the PO in the PO_Detail table but I just cant get the results to show this.

View 8 Replies View Related

Validation Rule By Relating Data With Table

Dec 18, 2013

I have tried several ways to validate my data with existing table I've developed.

Actually, I want the access to validate the data (Cellphone number) I've entered in the textbox by looking it in the existing table. So, if the data is there in the table, the message will pop up such as.. "Please continue". But if not, the message should be "this number was not registered yet.." and the textbox will be empty and ready for the new number...

View 14 Replies View Related

Tables :: Relating Transactions With Rate Master Table

Jan 28, 2013

I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants developing a much faster and customized approach to billing the customer based on payroll related information.

There is a table of payroll billing transactions and it has the following record lay-out,

job_num, employee number, employee name, union group, rank, regular hours, overtime hours, other hours, trans_date, seq_num

6430, 2301, john doe, 1, F, 8.0, 0.0, 0.0, 12/01/2012, 254333

On December 1st John Doe worked 8.0 regular hours as a pipefitter foreman on job number 6430 and this is record (sequence) number 254333.

There is another table that defines the union group. I am not concerned with this information at this time. The seq_num is a sequentially and uniquely assigned number given to each billing record in the main system.

There is also a Rate Master table and it has the following record layout,

job_num, union group, rank, regular_billing_rate, overtime_billing_rate, other_billing_rate

I am struggling as to how to relate these two tables so that I can develop some queries from it.

View 2 Replies View Related

Relating Tables

Aug 8, 2005

I have a table with the following fields: Login ID, Description Password, Login Type, Location, Status. For every Login ID there are some old passwords that had different effective dates. I want my form or table to behave so that I can enter all the old passwords with the effective dates and keep adding to this record. I know it has something to do with subforms but I don't know how to do it. Please help.
Thank you
Yusuf

View 1 Replies View Related

Relating Tables

Jul 27, 2007

I think this is probably going to be an embarrassingly simple question. I'm new to access and still struggling with the simplest of concepts...

I'm trying to relate three tables:

tblContacts
ContactID - autonumber, primary key
FirstName - text
more fields...

tblPrograms
ProgramID - autonumber, primary key
ProgramName - text
ProgramDesc - text

tblProgram_Contacts
ContactID - autonumber, primary key
ProgramID - number, primary key
ProgramName - text
Selected -true/false

I have a main form, Contacts, for the user to input all the necessary data about a contact. What I'm ultimately trying to do is also include a subform which contains the name of each program (there are 12 or so) with a true/false checkbox. I'd like it to work so that if a program is added, it automatically gets added to the subform with a checkbox.

Also, I'd like the results of that subform to get dumped into tblProgram_Contacts.


Sigh...

A great vision... but I really am not sure on how to do any of this (specifically, properly defining the relationships and properly constructing the subform). Any suggestions would be greatly appreciated!

View 3 Replies View Related

Relating Fields To Each Other

Nov 10, 2007

Hello everyone,

I'm trying to create a simple form for my sister's classroom. That is, if she types "set," the form will display "sett" as the homonym.

I created a main table with the following fields:

1. ID
2. Word (a combo box from the Word table)
3. Pronunciation
4. Homonym (a combox from the Word table)
5. Meaning.

A second table with one field:

1. Word
A. Which is the primary key, Indexed,
no Duplicates).

I'm lost on how to properly set this up like a dictionary type form and how to relate the word to the appropriate homonym.

Help! Please!!!

View 6 Replies View Related

Relating 2 Forms

Jun 21, 2007

Hi all. This is my first post on this particular message board. I'm having a little problem getting Access to do what I want and hopefully someone here can help me out.

I have 2 forms. One larger form called RTV and one smaller one called Product Line. Now, most of the fields that are in the Product Line form are also in the larger RTV form. What I want, is for the product line people to enter information into the product line form. Once they're done, they exit the database and then, later, their managers look at this information in the product line, verify that it's correct, and then hit a command button that transfers all the fields that are the same on both forms, to the RTV form.

For instance, a prod line person would come in, fill out a date, part number and PO number and hit add record. Then, a manager would get on that same form, make sure everything is ok, and send the data over to the end of the RTV table.

Also, the product line people should not be able to see or edit the RTV form. Only a few people should have the priveldge of seeing both forms. Anyone have any ideas?

View 3 Replies View Related

Question About Relating Tables Together

Oct 21, 2004

Hello,
I have a pretty basic question about creating relationships in Access. When in the relationship window that shows all tables and associated relationships, I am a bit confused as to whether you are to drag the parent field to the child field or vice versa. When trying both, it appears to create the 1 to many relationship in the same direction no matter what way I create the relationship. So I am hoping someone will explain this a bit further to me or at least direct me to a reasource to clear up my, and possibly others, confusion. Sorry for my ignorance on this one! :o
Thanks a lot,
Dana S.

View 4 Replies View Related

Autonumbers Relating To Another Field

Jan 12, 2005

Hi I have tried searching for an answer with no luck.
I am writing a table to do a filing cabinet archive.

I have a table with 3 fields in one is box no, second is item no and third is a description.

I have the first 2 linked as a primary key. The description is just text.
I want to be able to enter a box no and to have the second (item) to enter a number automatically following a sequential no which is relevant to that box. ie
box no Item No
1...........1
1...........2
1...........3
2...........1
2...........2
3...........1
1...........4 this one takes the next no available for box no 1
2...........3 and this one does the same for box no 2

if you go back to a box and start reinputting it picks up the next number.
should i sack trying to do it with the autonumber?

View 4 Replies View Related

Relating Subform To A Form

Mar 17, 2005

I'm having a bit of a problem figuring out how to do this...

I have a form (single form) and a subform (datasheet which is based on a query which includes the data elements [via outer join] in the single form). What I'm trying to do is have the data sheet form include (view only) all records from the query and have the single form display selected fields for edit/entry (will update a table that is the outer join in the query).

Example:

Table A has "Policy Number", "Line of Coverage", and "Insured ID".
Table B has "Policy Number", "Insured ID", and "Insured Name".

Query 1:
SELECT A."Policy Number", A."Line of Coverage", A."Insured ID", B."Insured Name"
FROM "Table A" A, "Table B" B
WHERE A."Policy Number" = B."Policy Number" (+)
AND A."Insured ID" = B."Insured ID" (+)

(+) means outer join (sorry i'm used to using oracle).

So in the form I have a single form (FORM X) bound to Table B and a datasheet subform (FORM Y) bound to Query 1. I would like the user to be able to edit (or add if it doesn't exist) the "Insured Name" in FORM X based on the record currently selected in FORM Y.

Other things that may monkey with the process are the fact that even though Table B will have a unique key based on "Policy Number" and "Insured ID" Query 1 (and Table A) may have multiple "Line of Coverage" based on a single "Policy Number" and "Insured ID" combination.

Alternatively not relating the two forms, but simply populating the FORM X based on the record selected in FORM Y would be sufficient. Would this involve populating FORM X using the "on focus" function and how do I use vb to reference to a specific record in my subform?

Please let me know if I am not making any sense and thank you for your help.

-Eric :eek:

View 1 Replies View Related

Relating 2 Cascade Combo Boxes

Apr 30, 2005

I need help relating 2 Cascade combo boxes
I need the coding I see the example online at
http://www.fontstuff.com/access/acctut10.htm

But I need the Coding it explains good how it works
CD Group
CD Name

Displays CD Group related to the fields in CD Name

Thanks,

Mike Va nDer STad

View 3 Replies View Related

Relating Assembled Part Numbers To Their Components

Feb 10, 2008

I didn't know which forum to post this in.

I'm stumped.

The inventory table has both cabinet assemblies and their components (tblInventoryMaster) in one table and a table that has what components go with each assembly (tblInventoryAssembly)

When a cabinet is sold, I need the ordering process to commit the components to ship (but still show the cabinet only on the order)

I've attached part of the database in question (Inventory tables, Order Form & relationships)

View 1 Replies View Related

Combo Box Relating To Variable Criteria In Query

Mar 16, 2006

I have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?

View 1 Replies View Related

Combo Box Relating To Variable Criteria In Query

Mar 16, 2006

I have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?

View 2 Replies View Related

Combo Box Relating To Variable Criteria In Query

Mar 16, 2006

I have an unbound Combo Box in a form that I would like to use to set criteria in the query. How do I do this?

View 3 Replies View Related

Opening A Form Relating To A Record In Datasheet

Jul 16, 2006

In Filemaker, when you open a table in datasheet view and then select a record you can then open the form relating to this record. Can you do this in Access - I can't get it to work.

View 2 Replies View Related

Displaying Records Relating To One Employee At A Time

May 6, 2013

I am currently creating a DB for a Customer Service team so management can keep track of who is skilled in what area, sick days, holidays etc. I have created three tables so far as follows:

EmployeeT with a primary key 'EmployeeID'

SickT with a primary key of 'SickID' and a foreign key of 'EmployeeID' linking to the EmployeeT (Reason behind this is that I may have multiple records for one Employee, meaning I would need a unique identifier)

SkillT with a primary key of 'EmployeeID' linking into the EmployeeT (Only possible to have one skill record linked to one employee)

Set up relationships as follows:

One EmployeeT to one SkillT
One EmployeeT to many SickT

I then created a blank form and used Tab Control.

On the first page I was able to populate the page with all the Employee info.
On the second page I was able to populate with all the skills relevant to the initial employee.

Then I tried populating sick records relating to the employee on a third page, but that's a no go. I was considering putting a subform on this page, but I wouldn't know where to even start with that.

View 1 Replies View Related

Modules & VBA :: Combo Box To Show Records Relating To A Specific Record

Jun 11, 2013

I have a combox field on subform C that shows records from a query.How do I get this combo to only show records that relate to an ID on subform B.I have a subform for storing contracts and these are stored against a company name.On subform C I have a field that currently shows all records in a table. I need this combo to only show the records that relate the current record on subform B?

View 4 Replies View Related

Select 1 Pce Of Data And It Automatically Selects And Inputs Relating Data In A Form

Oct 24, 2007

i would like in a form for a combo box to be able to select an item from a table and input relating information automatically into other boxes in the form..

I have 3 tables: Table 1 has product code and product description.
Table 2 has invoice number company details, address etc.
Table 3 has product code and product description qty and invoice number..
Table 3 relates to table 2 by the invoice number and table 3 product code looks up the product codes available in table 1 and also table 3 looks up the list of products descriptions in table 1 using the combo wizard.
This means the wrong code can be put with wrong description.
What i would like to know is how i select a product description and the product code in the form fills out automatically?? i hope this makes sense please helppppp!!

View 5 Replies View Related

Forms :: Relating Information Between Main Form And Navigation Forms

Apr 11, 2013

New to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.

I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...

I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.

View 1 Replies View Related

Using Subform For Search Criteria And Relating One Search Field To Several Columns

Apr 21, 2015

1. I created a form with some search-fields which are related to a query. Then I added a Subform in which I put some more Search criteria (So that I can easily hide and unhide those additional searchfields). It sounds strange but is necessary ;-). Now I related those searchfields in the subform to the same query. When I run that query a window pops up that I should put in a value in all those searchfields which are in the subform. But I told Access that it should display all rows, if there is no value in those searchfields. Just as I did it with the Searchcriteria in the Main form. Do I have to do something special, when I have a query which is related to two Forms?

2. I want a searchfield to search in three different columns. Usually the value will just be found in one of those columns. As the Table I search is very long and has many searchfields and multiple of those will relate to more than one column, is there an easy way to do it in VBA? As I did it by using the "or" field when designing a query, but this seems very slow and unstable.

View 6 Replies View Related

Tables :: Assigning IDs To Excel Imports And Relating Tables

Mar 5, 2014

I need assigning IDs across tables so I can relate them. I have two tables.

The first table contains data regarding schools.
SchoolID [autonumber, primary key]
SchoolName
SchoolPostcode

The second table contains data regarding children numbers in each year group for each school
VaccinationSessionID [Primary Key]
SchoolID [want this to match the school id assigned in the first table!]
SchoolName
WeekofVisit
YearGroup
StartingDenominator
Etc.

In the second table the data was imported from Excel, so all but the School ID was imported. Each school name appears 7+ times in the second table.

How do I get the school ID assigned to a school name in the first table, to automatically assign and fill in the (currently blank) School ID field in the second table? I want to remove school name from the second table eventually, to use the Primary Key school ID in the first table, and Foreign Key school ID in the second table.

View 13 Replies View Related

Forms :: Combo Box On Several Forms Relating To Corresponding Tables

Apr 25, 2013

I have created a database in which I have used a combo box on several forms relating to corresponding tables. These combo boxes all reference the same table with names (text fields) listed. I am having difficulties getting the data to feed into the table from the combo box using the form. Only the ID numbers appear in the table.

View 3 Replies View Related







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