Good day guys,

I am creating a system for saving details of a user, i have attributes (UserID(pk-Auto),name,surname,disability(FK)..

I have 3 tables, being [user(UserID(pk),Name,surname,disability(fk)],[disability(DisabilityID(pk),Disability(YES/NO)], and [disabilitype(DisabilityTypeID(PK),disabilityID(fk),UserID(fk),disabilityName)]

the disability have an option of yes/now(with the id for yes being 1 and 2 for no), if the user clicks yes the system must be able to save data on disabilityType and retrieve the PK of user of which it is unknown because the user details will saved afer the if statement of the disability attribute

Related posts

Recent Viewed