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.?
4  1429  
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.
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.?
???
"Relationship one-to-one". What does it means? Case Number is unique in each table? If so, why do you need 4 tables?
Please clarify.
I need 4 tables because there are too many fields for one table
???
"Relationship one-to-one". What does it means? Case Number is unique in each table? If so, why do you need 4 tables?
Please clarify.
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?
Sign in to post your reply or Sign up for a free account.
Similar topics
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',...
|
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...
|
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...
|
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.
...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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,...
|
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,...
|
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
