How to make database on this?

[eneyardi]

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):

METHOD --> METHOD1    METHOD2    METHOD3
              1          1          1
              2          2          2
              3          3          3

[NeoPa]

I fixed your layout problem but I still have absolutely no idea what your question is asking for help with :-(

[eneyardi]

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?

[NeoPa]

Still no idea what it is you're asking for. Sorry.

[eneyardi]

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

[NeoPa]

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.

[eneyardi]

Thank you NeoPa, can I attach picture showing what i want to achieve? may an illustration?
[IMGNOTHUMB]http://s14.postimg.org/6iditj3pt/Analysis.jpg[/IMGNOTHUMB]
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?

[NeoPa]

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.

[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 :

[B]Table=[[U]tblElement[/U]][/B]
ElementID    AutoNumber & PK
ElementName  String

[B]Table=[[U]tblMethod[/U]][/B]
MethodID     AutoNumber & PK
MethodName   String

[B]Table=[[U]tblResult[/U]][/B]
ResultID     AutoNumber & PK
ElementID    FK (tblElement)
MethodID     FK (tblMethod)
ResultVal    Double

[eneyardi]

Thank you Neopa, I have a better way now how to do it. Thanks alot

[eneyardi]

Neopa are these 3 tables have their own primary key? or only the tblResult must have the primary key?

[NeoPa]

tblResult is actually the only one of them where having a Primary Key (PK in the layout) is not essential.

[eneyardi]

Thank you again Neopa