Add a specific Record to a Table based on a check box

[Jazflux]

I have a Table called ServiceTypes. Based on a User's input on a
ProposalForm, ServiceTypes need to be added to a ProposalServicesTable.

For instance, I have a Check Box on the ProposalForm. When a Check Box is
clicked Yes, Access must search the ServiceTypes Table, select a specific
ServiceTypeID, and add the ServiceType to the ProposalServicesTable.

How can I add the proper Service record from the ServiceTable to the
ProposalServicesTable based on the Check Box?

 

[Dennis]

I wouldn't do it that way. I'd use a listbox (with multi-select set to YES)
that was sourced to the ServiceTable. I'd allow the user to select as many as
he wanted, then build a string to populate the ProposedService table. I'd
probably just use the codes associated with the service name(s), and build
the list of services at report-time.

 

[Jazflux]

The problem with your suggestion (unless I am missing something) is that the
User doesn't know what service he needs (they are technical in nature). I am
trying to use a standard english questionnaire to enable a technical services
selection from a table....I appreciate your response.

 

[Dennis]

So if I understand you, you have extended text at each checkbox (or ToolTips
enabled) to assist the user in determining which service(e) he needs?
Assuming that's true, I'd still build the responses into a single field in a
table.

For example, I recently did a Security Incident database. In that, one of
the tables was dedicated to "Suspect". Part of the suspect table was "HAIR".
Well, there are lots of things associated with hair: Long, Short, Brown,
Blonde,Grey (etc), Facial-beard, Facial-moustache and the like. So I built a
string based on the checkboxes that might look like this:

Short;Grey;Moustache

Then I placed that string into a single field in the Suspect table. In the
report, I broke the string out into its component parts for ease-of-reading.

That make sense?

 

[Jazflux]

Thanks Dennis, I will see if I can implement your suggestion in my context. I
appreciate it.