If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subform records
Hi there
I have a mainform which the user enters records into the tblevents and a subform which enters records into tblinvoice. Although the relationship between the tables is one to one, multiple rows appear in the tabular subform for a user to enter more than one record. Then of course should they attempt to an error message displays saying the changes will not be succesful as it weould create duplicate values in the pkey or relationship. Have I made a glaring error? Or is there an easy way to restrict entries to one record only on the subform that I have missed? Many thanks for your help |
#2
|
|||
|
|||
Subform records
no, you haven't made an error - the subform is working normally. since the
two tables have a one-to-one relationship, the easiest way to stop the user trying to enter a second record in the subform might be to set the subform's DefaultView property to Single Form, set the Cycle property to Current Record, and set the NavigationButtons property to No. hth "Jenny" wrote in message ... Hi there I have a mainform which the user enters records into the tblevents and a subform which enters records into tblinvoice. Although the relationship between the tables is one to one, multiple rows appear in the tabular subform for a user to enter more than one record. Then of course should they attempt to an error message displays saying the changes will not be succesful as it weould create duplicate values in the pkey or relationship. Have I made a glaring error? Or is there an easy way to restrict entries to one record only on the subform that I have missed? Many thanks for your help |
Thread Tools | |
Display Modes | |
|
|