I have a many/many relation set up where many employees can be associtated with many different accounts. Currently I have a relational combobox on the employee form to select which accounts they are connected to. However, the number of accounts can change over time. When they are no longer associated with an account I get an error trying to remove it saying "You tried to assign the Null value to a variable that is not a Variant data type". First, Is this the best way to try and keep track of this data? Second, can you help with my error message and configuring things correctly?
Sami Shamma
@Reply 2 years ago
In your cross-reference table, add a Yes/No field called IsActive. Set the default to Yes. so, when an employee is no longer associated with an account, just deactivate that record.
Richard advices never to delete records from the data base, just mark them inactive.
In my old job, we had sales reps who sold goods to customers. When a sales rep made a sale, the customerb would place an order, and the order would have the customer's and the sales rep's names on it. And that was how an "association" was made between the two parties. If there was no sale, no association was made.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
