473,586 Members | 2,855 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Table Relationship and Form Problem

83 New Member
I have 4 tables that are linked by a unique indexed case number. I want to have a form that allows you to create a new case and enter information to one of the tables, but still create a new case number in the other 3 tables.
I have tried creating a relationship-one to -one between the one table and the rest (Case Number to Case Number. )
I then created a query that brings them all together, but there are 4 different case numbers but I used one of them. but it doesn't create a new case in all the tables.?
Jun 8 '07 #1
4 1439
puppydogbuddy
1,923 Recognized Expert Top Contributor
I have 4 tables that are linked by a unique indexed case number. I want to have a form that allows you to create a new case and enter information to one of the tables, but still create a new case number in the other 3 tables.
I have tried creating a relationship-one to -one between the one table and the rest (Case Number to Case Number. )
I then created a query that brings them all together, but there are 4 different case numbers but I used one of them. but it doesn't create a new case in all the tables.?
I believe that In order for the case number to be generated in each of the related tables, you need to do the following:
:
1. set the table relationships for all tables such that referential integrity is enforced (checked) and cascade updates and deletes are checked.
2. in the relationship window, the case number field in one of the tables has to be designated as the Primary Table to each of the other 3 tables (the so called foreign key tables). This also implies that the structure and makeup of the case number in the primary and foreign tables has to be the same.
Jun 10 '07 #2
FishVal
2,653 Recognized Expert Specialist
I have 4 tables that are linked by a unique indexed case number. I want to have a form that allows you to create a new case and enter information to one of the tables, but still create a new case number in the other 3 tables.
I have tried creating a relationship-one to -one between the one table and the rest (Case Number to Case Number. )
I then created a query that brings them all together, but there are 4 different case numbers but I used one of them. but it doesn't create a new case in all the tables.?

???

"Relationsh ip one-to-one". What does it means? Case Number is unique in each table? If so, why do you need 4 tables?

Please clarify.
Jun 10 '07 #3
jl2886
83 New Member
I need 4 tables because there are too many fields for one table

???

"Relationsh ip one-to-one". What does it means? Case Number is unique in each table? If so, why do you need 4 tables?

Please clarify.
Jun 11 '07 #4
FishVal
2,653 Recognized Expert Specialist
I need 4 tables because there are too many fields for one table
Sorry. It seems to me your db is not normalized.
Is it so?
By the way how do you want to represent >255 fields (1000 ?? in 4 tables to keep within access limits :)) on a form?
Jun 11 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2131
by: Terry | last post by:
I need some help refining an MS 2000 relational databse. I have created a simple relational database using two tables, 'Student Details', 'Exam Details' and two forms, 'Input/Edit Exam Details', 'Input/Edit Student Details'. 'Student Details' has a field called 'Log Book No' (no duplicates allowed) and this is the Primary Key. 'Exam...
5
3739
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for Office 2000. I am creating a database to track student athletes. I have created the following tables. The table title is to the far left, with fields...
0
1356
by: rocsolid | last post by:
Current problem deals with three tables in my database. The "DOCUMENTSLIST" table has a one-to-many relationship to the junction table (DOCUMENTS/PROJECTS) which, in turn, has a many-to-one relationship to the "PROJECTS" table. The tables have the following fields: DOCUMENTSLIST DOCUMENTS/PROJECTS PROJECTS Document ID (P...
3
1968
by: CAD Fiend | last post by:
Hello, I have a land development project that has a many-to-many relationship. I have ONE question regarding table structures, and ONE question on how to make a Form with two Subforms, below. TABLE STRUCTURE QUESTION: There are two parts to this preface.
117
18469
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of elements in the HTML to get everything just right. When you consider the class attribute on the DIV elements, there's not much size savings anymore...
3
6189
by: KayC | last post by:
Hi Background info: I am running Access 2000 I have a form bound to a blank table When a user clicks a button the form opens in datasheet view User enters data into form and closes form User clicks button which then creates an inner join between form bound table and master table and updates records in master table where values are equal...
76
271567
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if...
2
1963
by: Leventcos21 | last post by:
Hi all, I have been stuck on this issue for weeks now and can not find a solution, so I hoping that someone can help me out. I am setting up a training database. I have setup the structure and started working on the forms and encountered an issue that has me baffeled. ***Table Info**** Employees have skill sets and it is a M:M relationship...
3
3175
by: TonyJH226 | last post by:
I’m using Access 2003 and am a novice to Access. I am creating a form to facilitate data entry to seven tables. The main table (A) has four sub-tables that are related to the main table by one-to-one relationships. A fifth sub-table (B) has a one-to-many relationship to Table A and serves as a bridge to another table (C) also with a...
4
2153
by: jbrumbau | last post by:
Hello, I have been successfully using a database I've created for several months to populate an equipment list for a project we've been working on. However, the form has recently stopped working for some unknown reason. I've been having a problem recently where one table (Project Info) keeps auto-incrementing when I try to create a new record...
0
7911
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8200
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8338
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7954
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5710
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5390
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3836
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3864
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2345
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.