combo box problem

[rashidzaib]

hy
i hope all r fine
i am facing problem in combo box. here i have master/detail form and this is working fine without combox. when i am creating combobox for list of item and go to that item the record is showing. but when i click on detail record then it is giving the problem of primary key r duplicaation and i can not go further and reciving continuosly that error. i have created lcomb box on primary key. combox on other record is working fine.
any solution should realy be appriciated.
thank u bye

 

[neileg]

Why do you have a combo box bound to the primary key? Primary keys need to be unique, so giving the user a choice contradicts this.

 

[rashidzaib]

combo box

hy thank u for ur reply.
if i will not make combo then what i will do if user want to modify the detail record.
the only to select the required record from the list. i dont have any other option
if i use it as unbound then i am not able to save the data. msg is coming primary key can not be null.if unbound the previous problem is solved but i am not able to save the data in master table. any solution should realy be appriciated.
thank u and best regard
ur truly
rashid zaib
bye

 

[Katy]

Hi, Are you using the combo box to search for a particular record? If so, you can use an unbound combo box which lists all the records' primary keys and locates a record and also have your primary key as a separate text box. Primary keys should not generally be edited, you shouldn't use names etc as primary keys

 

[neileg]

I agree with Katy. I don't ever use a primary key that has meaning to the user, so I never need them to be able to edit it. I would use an autonumber as a PK. Then you can let the user edit the field that used to be your PK.

 

[rashidzaib]

combo box

hy i hope all r fine
first of all thank u very very much for reply. i understand ur logic.
u r right. but i was using logic of oracle
. i have got it.
thank u
take care
bye