Primary key

[vugar]

could you please help?
can I create primary key with macros avtomaticaly.
I have created table with Query and I need primary key in this table. I put new field for primary key but after restarting it was delete every time.

[June7]

Why are you creating table with query?

[vugar]

I must get sum information from another table.

[June7]

That's what queries are for. Why is there a need to make a table?

Look at the last example in https://msdn.microsoft.com/en-us/lib...or=-2147217396

[vugar]

I must create table from query so I can use it in another query to input data.

Could you please tell can I write SQL for greate field (primary key) for appent query?

[Homegrownandy]

Just have an auto number field that generates a sequential number. Although as June said, this doesn't seem like the best idea. You will have several copies of the same data, which defeats the object of a database.

[vugar]

I'm trying to create warehouse DB, and in outgoing table I try select items from incoming table. in incoming table may be many recors so I create Query with grouping items and I can create relation without primary key.

[vugar]

How I can use it's query for using for input in another table?

[June7]

Still don't understand why you need to make table. A query can be used in another query.

Can't create primary key with an append query.

Seems there is a language barrier but you really need to provide complete info on what you are really trying to accomplish so we can advise on best approach to get it done. So far, little of what you have provided makes any sense.

[vugar]

WDB.zip

please see attached file.

I'm trying to select items from "catalog for outgoing query" in "Outgoing".

Could you please tell how can I do it?

[vugar]

One question more.

how to make so that if I remove primary keys from table in another table where I added data with this table, do not delete records. ?

[Homegrownandy]

Why would you need to remove keys?

[orange]

vugar,

Could you please give readers an overview of what your business is? You are asking questions without any business context, so readers may only guess at what you are trying to do.
You really haven't addressed June's question

why you need to make table.

Your database is a representation of How you have done something. Readers don't know what the business and business facts are, so can not relate your database to a set of requirements.
You will get more focused answers if you provide some context, background and details with your questions.

[June7]

I looked at your db and that did not help me understand what you are trying to accomplish.

[vugar]

I'm trying to construct Warehouse DB.