Re: Foreign Language in Menu items

Thanks Mike, You have taught me how to make table starting from SQL view. I
did itwith the conventinal way, adding row and then I press ctrl then the
icon key, then the 4 colums become primary key, but when I simulated it by
filling the data it was rejected because my concept of multiple primary key
is still wrong. then when I read your posting I rethink it and should view
the 4 as 1 primary key when filling the data, then I understand now.

So thank you very much, and I still see that clicking the default button is
sill used to choose the languange to be used, right?. Yes, after clicking
the default to choose the language and churchID, then I wll make it .MDE
format before I send the software to the user.

One issue maybe when I fill in the Korean, or Japanese language which are
not Latin alphabet. could it be working?. Anyway let me do it step by step.
After langguage issue, maybe the next which I think maybe the last is
creating the menu for import/exporting as the way to consolidate the data in
the Regions, Union dan Division's levels.


Thanks & Regards



--
H. Frank Situmorang


"Michael Gramelspacher" wrote:

On Thu, 4 Dec 2008 07:19:07 -0800, Frank Situmorang <hfsitumo2001@xxxxxxxxx> wrote:

Thanks very much Mike. I will try to understand it thoroughly. I think I
decided to use Dale's suggestion as it is more traceable and more
comprehensive.

My knowledge is increased litte by little, so I appreciate if you could also
explain how can it be the 4 primary keys, but it can duplicate, normally PK
can not duplicate data. Also in the design view of the table we do not even
see tthe field property that says allow duplicate or not. Could you tell me
how do you desingn it that way. Before, I have seen the bulit in access main
swithchboard items used this kind of approac of table, but I still can not
understand how the primary key could duplicate data in it.

Thanks very much.

Frank

You could select New Query, add no tables, and switch Query Design View to
SQL and copy this and paste it into the SQL window. Save it and run it. Your table is created.

CREATE TABLE FormLabels (
FormName TEXT(50) NOT NULL,
Language TEXT(50) NOT NULL,
CtrlName TEXT(50) NOT NULL,
CtrlProperty TEXT(50) NOT NULL,
CtrlValue TEXT(100),
PRIMARY KEY (FormName, Language,
CtrlName, CtrlProperty)
);

Now you still need to open the table in design view and add the Validation Rule for the column
CtrlProperty.

Is your question that you do not understand the concept of a multiple-column primary key? Or maybe
it is that you do not know how to do it in table design view? Just select the four fields and press
the Primary Key Icon on the Toolbar.

A primary key cannot have duplicate data. There cannot be two rows where columns FormName,
Language,CtrlName and CtrlProperty have the same data. That would violate the primary key and the
database would reject the duplicate row.

I have a feeling that I am still not answering your question.

.

Loading