Click here to Skip to main content
15,850,359 members
Home / Discussions / Database
   

Database

 
GeneralRe: Http 500 error with register page Pin
Richard MacCutchan1-Jul-20 23:37
mveRichard MacCutchan1-Jul-20 23:37 
GeneralRe: Http 500 error with register page Pin
and180y2-Jul-20 5:57
and180y2-Jul-20 5:57 
QuestionReporting data Pin
Joan M19-Jun-20 11:03
professionalJoan M19-Jun-20 11:03 
AnswerRe: Reporting data Pin
Mycroft Holmes19-Jun-20 13:25
professionalMycroft Holmes19-Jun-20 13:25 
GeneralRe: Reporting data Pin
Joan M20-Jun-20 2:11
professionalJoan M20-Jun-20 2:11 
GeneralRe: Reporting data Pin
David Mujica22-Jun-20 5:27
David Mujica22-Jun-20 5:27 
GeneralRe: Reporting data Pin
Joan M22-Jun-20 9:40
professionalJoan M22-Jun-20 9:40 
Questionhow to create relationship between tables based on field Pin
Cenator13-Jun-20 3:12
Cenator13-Jun-20 3:12 
First of all: "Sorry for my english!" I recently have created a calibration database via Ms Access DBMS. Here is the model:

https://i.stack.imgur.com/Z2uBf.jpg[^]

Each tool has "name abzarLa" field that is actually "Tool's English Name" that comes from ToolList Table. Here is sample values of "ToolList" Table.

https://i.stack.imgur.com/cPwSk.jpg[^]

now it's time to explain my problem: each Tool based on its "name abzarLa" relates to its specific "Data Table" which contains Calibration data results with specific fields. (One To Many relationship => each tools has multiple row in "Data Table") Here is data table that uses for insert "Pressure gauge" results:

https://i.stack.imgur.com/ZEQ7e.jpg
[^]

And here is data table that uses for insert "Oven", "incubaor", "cold Incubator" results:

https://i.stack.imgur.com/4uzOp.jpg[^]

Ok, So we have a Tools table and multiple "Data Tables". How can I design "Data Tables" and create relationship between "Tools" table and "Data Tables" base on "name abzarLa" field?
One Design is:

https://i.stack.imgur.com/6bhdu.jpg[^]


but I want each tool only relates with its specific [Data Table]
AnswerRe: how to create relationship between tables based on field Pin
Richard Deeming15-Jun-20 1:59
mveRichard Deeming15-Jun-20 1:59 
Questiondriver oracle 9i por .net Pin
Member 148339584-Jun-20 4:11
Member 148339584-Jun-20 4:11 
AnswerRe: driver oracle 9i por .net Pin
Richard MacCutchan4-Jun-20 4:14
mveRichard MacCutchan4-Jun-20 4:14 
AnswerRe: driver oracle 9i por .net Pin
Jörgen Andersson4-Jun-20 5:29
professionalJörgen Andersson4-Jun-20 5:29 
GeneralRe: driver oracle 9i por .net Pin
Member 148339584-Jun-20 23:25
Member 148339584-Jun-20 23:25 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson5-Jun-20 2:08
professionalJörgen Andersson5-Jun-20 2:08 
GeneralRe: driver oracle 9i por .net Pin
Member 148339587-Jun-20 22:58
Member 148339587-Jun-20 22:58 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson8-Jun-20 0:20
professionalJörgen Andersson8-Jun-20 0:20 
GeneralRe: driver oracle 9i por .net Pin
Member 148339589-Jun-20 5:27
Member 148339589-Jun-20 5:27 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson9-Jun-20 5:45
professionalJörgen Andersson9-Jun-20 5:45 
GeneralRe: driver oracle 9i por .net Pin
Member 148339589-Jun-20 5:27
Member 148339589-Jun-20 5:27 
QuestionFailed to connect Mysql shared server database with Workbench 8.0.20 tool. Pin
Member 1167692314-May-20 23:49
Member 1167692314-May-20 23:49 
AnswerRe: Failed to connect Mysql shared server database with Workbench 8.0.20 tool. Pin
Bohdan Stupak29-Jun-20 5:26
professionalBohdan Stupak29-Jun-20 5:26 
Questionatabase constraints must follow relvar constraints Pin
Tara1112-May-20 15:15
Tara1112-May-20 15:15 
QuestionConvert raw byte[8192] of SQL Server XML datatype into a C# string? Pin
arnold_w1-May-20 3:32
arnold_w1-May-20 3:32 
AnswerRe: Convert raw byte[8192] of SQL Server XML datatype into a C# string? Pin
phil.o1-May-20 4:06
professionalphil.o1-May-20 4:06 
QuestionRead data from Azure database with C#-application, without installing a lot of applications? Pin
arnold_w25-Apr-20 8:24
arnold_w25-Apr-20 8:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.