Re: Foreign Language in Menu items

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.
.

Relevant Pages

  • Re: Foreign Language in Menu items
    ... I forgot to say that I plan to make foreign language for reports too. ... understand how the primary key could duplicate data in it. ... You could select New Query, add no tables, and switch Query Design View to ...
    (microsoft.public.access.formscoding)
  • Re: Foreign Language in Menu items
    ... You have taught me how to make table starting from SQL view. ... filling the data it was rejected because my concept of multiple primary key ... One issue maybe when I fill in the Korean, or Japanese language which are ... understand how the primary key could duplicate data in it. ...
    (microsoft.public.access.formscoding)
  • Re: Foreign Language in Menu items
    ... understand how the primary key could duplicate data in it. ... I can make the table's fields with their primary key, ... The other thing is the VBA Public Sub LanguageControls() a module? ... I think this can only be done in a .mdb file, ...
    (microsoft.public.access.formscoding)
  • Over 500 Tasks; Yes/No in project?
    ... I have a table that has over 500 records and those records have a 'taskId' ... Each project has it's own ID also as the primary key. ... My concern is that I don't duplicate data already available in tables and ... a master plan for the project of what tasks are in this project. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Relationship question
    ... the design as a separate identity. ... CONTACTS_ID (Primary Key - Autonumber) ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)