I want to append data into 2 colums
I have 4 checkbox on a form when they are checked trueI want to append the MemberID to a table.
That leaves the ServiceID null,
If check box A is true 1 want the serviceID to be 1
If check box B is true 1 want the serviceID to be 2
If check box C is true 1 want the serviceID to be 3
If check box D is true 1 want the serviceID to be4
i cannot use an update after the record insertion because I want to create a unique index.
I thought of changing teh default value bit I am using a SQL server 2005 back end with an MS Access 2010 front end