Recent content by dannydm

finally sussed it out, SQL manager has a option on the indexe's properties to create unique and that was checked, as soon as you uncheck that, and of course update your linked tables, you can add more than one record on the subform. Thanks for all your help guys!

that is checked but the table is a linked table with sql server, how do i change that in sql server. the identity field on the properties for the column is not selectable or changeable....

hi, i have a form with a sub-form on it. each has is bound to a table. the main form's table has a one to many relationship with the sub-form table, and the sub-form table has the PK of the main table as a FK. every time i try to add a second record to the sub form, it gives me an error...

how do i do that? cant find any option for indexing with no duplicates....

Hi guys, i have a form which has a sub-form on it. each one is bound to a different table. the main form has a one to many relationship with the subform, but every time i try to add a new record to the subform i get an error say that you cant insert a duplicate foreign key. not sure how to...

ok thanks that worked out great!

Hi Guys, i have a problem i hope some one can help me with. i have a form with a sub form on it, and i want to disable everything until the user clicks a 'edit' button to allow the information to be changed. i am just testing it at the moment, so i set one text box's enabled property to...