Set-Up Question

[jo15765]

I have a linked SQL Server table into my Access 2013 database. It holds customer information and loads it onto a form. I need a way from the form to set a customer as active, or inactive. I was thinking of adding in a check box, and adding a bit column to my SQL Server Table. However, I have had big issues when my SQL table has a bit column.



Is there a different way for me to do this set-up or a different field type I can use in SQL Server and still use check box?

[Micron]

What about an Access table linked on custID and have the boolean field in the Access table?

[jo15765]

What about an Access table linked on custID and have the boolean field in the Access table?

You are saying to create a secondary access table and join on custID and update this table based off the checkbox selection?

[Micron]

Yup. You should be able to return all customer info from the sql table plus customer status from the Access table.

[jwhite]

An additional thought... If it might be helpful in the future to know when a Customer went Inactive, create a DateInActive field - if it is populated then the Customer is InActive, and you will know when that occurred.

[Micron]

Agreed. In fact I've suggested that before in similar threads, noting that if the field is Null, the status is active, otherwise the date infers inactive. I guess this time I focused on status. It's when there's more than 2 possibilities that the date alone is insufficient. So if there's to be Active, Inactive, Pending, etc. then the date has to be an additional field and I would call that one StatusDate.