Database design

Hi All,

I wanted the expert opinion out there in the use of foreign keys as
primary keys in a table. I am not very good at explaining this
concept, but I am going to try -

Let us say you have a parent/master table( Ex: purchase order) that
is generating number (primary key for the main table)using the seed
and increment specified. We need all the records of this table to be
in sequential order - i.e. we need all purchase orders to be in
sequence. Now there are two different types purchase orders different
enough to have entity/tables of their own. So what are the downsides
of using the primary key generated in the main table which would
normally be a foreign key to the child table, as the actual primary
key in the child tables.



Thanks

KR

.

Relevant Pages

  • Re: Discussion: What are the advantages/disadvantages to combinati
    ... when using the foreign keys from the parent tables as the combo ... primary key of the child table, ... i've used that child table in turn as the parent of another table, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database design
    ... from the master table, and use it as the PK in the detail table as ... is generating number (primary key for the main table)using the seed ... Now there are two different types purchase orders different ... key in the child tables. ...
    (comp.databases.ms-sqlserver)
  • Re: MS Access
    ... primary key has some blank, ... We can call this our parent or so called "main" table. ... you must declare a new column in this child table. ... In the above you can tell the customer with an id of 2 has a favorite color ...
    (microsoft.public.access.gettingstarted)
  • Re: Add new record automatically
    ... a record in the parent table. ... methods to add related records to any child table, ... combobox control bound to the foreign key field, ... with a couple different options on providing the primary key value of the ...
    (microsoft.public.access.forms)
  • Re: How to deal with cascading changes?
    ... I have two tables: Parent and Child. ... This primary key is also part of the primary key of table Child. ... In the database the primary key will cascade to table Child. ...
    (microsoft.public.dotnet.framework.adonet)