Re: Can I use combination of 2 fields as a Primary Key?

Ok;
Then i want to use this index as One side of a One-To-Many relationship and
force Referential integrity>Cascade Delete for this relation.This is my goal
of making this index.Is it possible?
Thank you for your attention.


"MacDermott" <macdermott@xxxxxxxxxx> wrote in message
news:eR1R$fhmFHA.860@xxxxxxxxxxxxxxxxxxxxxxx
> Yes, it is possible.
> In the Index Dialog Box, at the bottom, set Primary Key to True.
>
> HTH
>
> "Mota" <tavassoli68@xxxxxxxxxxx> wrote in message
> news:eVgCKCgmFHA.4028@xxxxxxxxxxxxxxxxxxxxxxx
>> Hello;
>> I defined 2 field of [Table1] as a unique index for this table.Fields are
>> [SQ]+[SN] and the index name is SQN.
>> My purpose of making this index is to use it as One side of a One-To-Many
>> relationship,then force cascade delete for it.But i dont know how to do
>> this.
>> Is it possible to use a combined Index,instead of a field,for such
>> relationships?Any help is appreciated.
>> Thank you in advance.
>>
>>
>
>


.

Relevant Pages

  • Re: Can I use combination of 2 fields as a Primary Key?
    ... >> HTH ... >>> My purpose of making this index is to use it as One side of a ... >>> relationship,then force cascade delete for it.But i dont know how to do ...
    (microsoft.public.access.formscoding)
  • Re: OneTouch hard drive enquiry
    ... >use of firewire is because I dont have any free USB2 ports and I dont want ... > HTH - Any Advice Appreciated - Please Reply To Newsgroup Only ...
    (microsoft.public.windowsxp.hardware)
  • Re: create n tables, with 20 o less records from one table with macros
    ... principles. ... i want to do a macro but I dont ...
    (microsoft.public.access.macros)
  • copy error
    ... each time through loop ... It also returns a '1' which I dont not understand since it ... Shouldnt it be '0'? ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: what am i missing
    ... If your sproc is being filled into a datatable, ... I think that is legal syntax for an expression... ... HTH, ... >> and i generally dont use the method you are using ... ...
    (microsoft.public.dotnet.framework.aspnet)
Loading