This is regarding the last post 'The use of Delphi with Access' To Justmade: I have a question regarding your table layout suggestion. If (History Table) Order Number (Primary Key) Order Time (Detail Table) Order Number (Primary Key) Dish ID (Primary Key) Quantity If both Order Number is set to Primary Key, It will be a One to One basic, however, it will be many items under the same OrderNumber in the Detail Table. Also, I cannot set two primary keys in the same table

引言: If both Order Number is set to Primary Key, It will be a One to One basic, however, it will be many items under the same OrderNumber in the Detail Table. Also, I cannot set two primary keys in the same table

Hi, you can select both Order Number and Dish ID from Detail Table and set a compound primary key which combined with more than one column. It's not to set two independent primary keys in one table. Each table only has one primary key.

引言: it will be many items under the same OrderNumber in the Detail Table

It is exactly why you need to use both the Order Number and Dish ID to be the primary key. A primary key cannot have repeated value. So, if you set OrderNumber as primary key, you can only have 1 record per Order Number. However, if you use both, you can have many records with same Order Number provided that the Dish ID is different.

Cool Cool.Thanx Tim    Justmade, can u plz help me further on my project? u helped me along the whole way, might as well bring me to the end. plz plz.. I just can't figure things out by my own