473,320 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to make database on this?

180 100+
How to make database with this;
Field name is [METHOD] then under [METHOD] there are selection of [METHOD1], [METHOD2, [METHOD3]
then under [METHOD1] there is a value [1,2,3] then in [METHOD2] there is also a value of [1,2,3] and also for the [METHOD3]

this is the output (disregard the arrow):

Expand|Select|Wrap|Line Numbers
  1. METHOD --> METHOD1    METHOD2    METHOD3
  2.               1          1          1
  3.               2          2          2
  4.               3          3          3
Jan 22 '15 #1

✓ answered by NeoPa

Looking at your data further I have a basic understanding that Method probably refers to a specific process or experiment done with a single element (at a time at least).

For this you would need a table of methods (tblMethod), a table of elements (tblElement) and a table of results which linked to both the element and the method (tblResult). tblElement & tblMethod would then be considered parents of tblResult so that each tblResult record had links to both tblElement and tblMethod.

At its most basic this might look like :

Expand|Select|Wrap|Line Numbers
  1. Table=[tblElement]
  2. ElementID    AutoNumber & PK
  3. ElementName  String
Expand|Select|Wrap|Line Numbers
  1. Table=[tblMethod]
  2. MethodID     AutoNumber & PK
  3. MethodName   String
Expand|Select|Wrap|Line Numbers
  1. Table=[tblResult]
  2. ResultID     AutoNumber & PK
  3. ElementID    FK (tblElement)
  4. MethodID     FK (tblMethod)
  5. ResultVal    Double

12 1190
NeoPa
32,556 Expert Mod 16PB
I fixed your layout problem but I still have absolutely no idea what your question is asking for help with :-(
Jan 23 '15 #2
eneyardi
180 100+
thank you for your reply Neopa, My question is how can I do that in creating a table. the METHOD is the field name, then the data fields are METHOD1, METHOD2 and METHOD3. then under them there are values 1, 2, 3
Can it be design in table or there is a way to do the sub datasheet?
Jan 23 '15 #3
NeoPa
32,556 Expert Mod 16PB
Still no idea what it is you're asking for. Sorry.
Jan 23 '15 #4
eneyardi
180 100+
is it possible to have a field name then under it there is a data field that will serve also as seconday field name then under it is the data field
example. field name
secondary field name
data field
Jan 24 '15 #5
NeoPa
32,556 Expert Mod 16PB
A field in Access is similar to a column in Excel. This should not be confused with a control, which is an item on an object such as a form or report. Typically, controls can display data from available fields in Access.

I can see no scenario except one where your question makes any sense at all, and I'm trying hard to guess what it is you're talking about. The relationship of a field to its data is not flexible. There is a field and it contains data. That is one of the most basic concepts we are dealing with in databases anywhere.

However, if you mean control when you say field the first time but field when you say it the next time then it's conceivable you're asking if it's possible to have a control on a form that shows data from one field in certain circumstances but data from other fields in other circumstances. That is possible. You can change the relationship between a control and a field in design mode or even in code when the form is open.

I may still have misunderstood you completely, of course, but that's my best guess of what you're saying.
Jan 24 '15 #6
eneyardi
180 100+
Thank you NeoPa, can I attach picture showing what i want to achieve? may an illustration?


The picture link above is the example I want to achieve in microsoft access table or form in datasheet view or single form. Is this possible to make in access?
Jan 30 '15 #7
NeoPa
32,556 Expert Mod 16PB
I suspect that is possible. There is still too little information to describe exactly what you do want, and the design (If I understand you correctly at all) would not involve anything more complicated than tables and fields even so.

The trick would be to design the table and fields in such a way as to allow for the data you have to be presented.

The numbers you show have no value that they match in the left column - so that makes reading your mind a little tricky. Nor is there any explanation as to how the two separate string values in the top two rows relate to each other. One can assume that they both relate to all the numbers in the column below, but we're still left with many more questions than answers.

Hopefully though, it helps to say that such data can be stored and shown with an appropriate table/field structure. I just can't tell you what that is without a better understanding of your intended data structure.
Feb 1 '15 #8
NeoPa
32,556 Expert Mod 16PB
Looking at your data further I have a basic understanding that Method probably refers to a specific process or experiment done with a single element (at a time at least).

For this you would need a table of methods (tblMethod), a table of elements (tblElement) and a table of results which linked to both the element and the method (tblResult). tblElement & tblMethod would then be considered parents of tblResult so that each tblResult record had links to both tblElement and tblMethod.

At its most basic this might look like :

Expand|Select|Wrap|Line Numbers
  1. Table=[tblElement]
  2. ElementID    AutoNumber & PK
  3. ElementName  String
Expand|Select|Wrap|Line Numbers
  1. Table=[tblMethod]
  2. MethodID     AutoNumber & PK
  3. MethodName   String
Expand|Select|Wrap|Line Numbers
  1. Table=[tblResult]
  2. ResultID     AutoNumber & PK
  3. ElementID    FK (tblElement)
  4. MethodID     FK (tblMethod)
  5. ResultVal    Double
Feb 1 '15 #9
eneyardi
180 100+
Thank you Neopa, I have a better way now how to do it. Thanks alot
Feb 2 '15 #10
eneyardi
180 100+
Neopa are these 3 tables have their own primary key? or only the tblResult must have the primary key?
Feb 2 '15 #11
NeoPa
32,556 Expert Mod 16PB
tblResult is actually the only one of them where having a Primary Key (PK in the layout) is not essential.
Feb 2 '15 #12
eneyardi
180 100+
Thank you again Neopa
Feb 2 '15 #13

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

Similar topics

5
by: stachu | last post by:
I make Database in Ms Access at order I good read but week speech and understand speech, If You want take me order please exactly describe working of database stachu from Poland mail:...
1
by: samuelgreene | last post by:
Hello, I have a front-end access db on a server share - the users should COPY the db to their desktop - but we know how that goes. I've tried to make it read only and have denied execute...
3
by: Jerry | last post by:
Hopefully this is the right group to ask. I am new to databases and I want to build a database to record maintenance for my car to learn with. I would appreciate any suggestions for fields to use...
2
by: Ryan Liu | last post by:
Hi, There is a method Test() implemented in base class and override in subclass. In base class itself, how to make sure this.Test() will just call implementation in base class only? ...
1
by: AngelaA | last post by:
The syntax to access a table is Select .. . How do I make the DatabaseName a variable – ideally to be passed as a parameter into the stored procedure? The reason being my test database uses a...
1
by: sama emad | last post by:
how we can make database with ASP.NET in net page ?
2
by: Scorp Scorp | last post by:
While am building my database project (.accdb) file, i need some to give this access file to somebody to have a look on the tables, forms and reports. But what i dont need is, i dont want to them...
1
by: omar hazim | last post by:
haw to make commands database in vb6 for example command delete + save + find + repleas....... pleas help me i need to answar this question
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.