Multiple value look up question

[Ricekrispycan]

I'm having a bit of an issue with my multi value look up. I have no idea if this is possible or not but, I have a look up, with multiple values, and multiple columns. I was wondering if it's possible to put a selectable yes/no check box in more than one column. For example, I have a programs column, and an opt in and opt out column. I want to be able to select multiple programs, and choose whether or not the user wants to opt in or opt out of said programs. Is this possible?



I've attached a photo that will hopefully better illustrate what I'm trying to say.

Thanks in advance!

[June7]

I believe the answer is no.

I NEVER use multi-value fields.

[Ricekrispycan]

Ok, do you have any idea how I might be able to accomplish what I'm looking to, without a multi-value field? I'd rather not use one if I didn't have to, to be honest.

[June7]

A related table and subform.

[Ricekrispycan]

Thanks for taking the time to answer, and I apologize, but I'm still a bit new to Access development. Do you think you could expound on that?

[June7]

I don't understand your data so hard to be specific. If you want multiple tests associated with some other entity (customer, employee, ?), this is a many-to-many relationship and requires a 'junction' table.

This is basic database concept. Perhaps this tutorial site will help: http://www.rogersaccesslibrary.com/

[Ricekrispycan]

I have a table called programs, which is populated with a bunch of insurance programs, and three other columns called opt in opt out, and custom. I need to be able to choose one (or many) programs and also select if each program needs to be opted in, opted out, customized, all, or neither. Preferably via check box if that's possible.

[June7]

Sorry, that doesn't make much sense to me. Opted In/Out by whom/what? Choose them for what?

Opt In/Out really should be only 1 field since a record can be only one or the other, not both. Not sure about customized, all, neither.

[Ricekrispycan]

Ok, sorry, let me try and word everything better. I have a table called Programs, this table is populated by insurance programs. Each insurance program can either be opted in, opted out of. What I want to do is create a form which allows the end user to select one, or many of the insurance programs, and select if they want to opt in or opt out.

[June7]

Did you work through the tutorial?

If you want users to select insurance programs, then a related table will have records only for selected programs. They 'opt in' by selecting a program and a record is created. This is conventional approach for relational data.