H
HearSay
I am getting ready to go-live with a website that has a Access backend.
I ran into a little problem, one of my fields didn't come across. I need to
update every record based on a certain criteria.
Here is a query I created. It contains two rows HRNG ID and ISSUES. My
main table called tblCalendar contains a new field called HearingIssues
I need to find a match on HrngID and update the HearingIssues field with
each issue. An example
qryHearingIssues HrngID Issues
341 Compensability
342 Compensability
347 Permanency/Perm Partial
347 Settlement
349 Medical Authorization/Utilization
349 Permanency/Perm Partial
349 Settlement
350 Compensability
Record 341 would be just Compensability (no problems)
Record 349, I would need Medical Authorization, Permanency, Settlement (all
on one line), this is where I need assistance.
I know about relationships, but they are using a listbox to select multiple
items and this is all done via ASP code and relationships won't work.
I ran into a little problem, one of my fields didn't come across. I need to
update every record based on a certain criteria.
Here is a query I created. It contains two rows HRNG ID and ISSUES. My
main table called tblCalendar contains a new field called HearingIssues
I need to find a match on HrngID and update the HearingIssues field with
each issue. An example
qryHearingIssues HrngID Issues
341 Compensability
342 Compensability
347 Permanency/Perm Partial
347 Settlement
349 Medical Authorization/Utilization
349 Permanency/Perm Partial
349 Settlement
350 Compensability
Record 341 would be just Compensability (no problems)
Record 349, I would need Medical Authorization, Permanency, Settlement (all
on one line), this is where I need assistance.
I know about relationships, but they are using a listbox to select multiple
items and this is all done via ASP code and relationships won't work.