All -

I want to know If I can have any Parent/Child relationship between the following tables. In table B I have A_ID which is not null and that is the only key to map with Table A. Please note that A_ID is nullable in Table A.

This is current tables defined in our application and I am trying to resolve an issue and I am going nowhere.

Table A {

A_SEQ_ID Primary Key

A_ID Nullable

A_Name

}

---------------------

Table B {
A_ID Not Null

B_Name

B_Update_date
}

Thanks