Giving Multiple Records one value in Form or Subform

[educate889]

Please help

I have searched the site and can't find anything on the following . . .

I have a form that tracks Cust. Complaints, that I assign a autonumber to. A customer may have multiple "jobs/ workorders" that they have concerns about, each gets own CC# (CustComplaint#).

Then when the Quality dept. acts on the complaints it assigns their own number. The problem is they might give credit or Return Auth to 3 cust complaints under one QA#.

Is there an easy way to use a subform to multiselect certain cust. complaints (CC#'s) and assign them all a particular QA# (hopefully auto generated).

Example of what I was hoping . . .
Complaints:
Customer Job CC#
ABC Design 1234 100
1235 101
2336 102


Return Auth:
QA# CC#
ABC Design 4000 101
4000 102

I would appreciate any help or ideas . . . I don't mind researching /testing just need a direction to head so I don't waste too much (more) time.

Look forward to hearing from some of the experts.

 

[Darrylles]

Hi,

HOW does the Quality Department select complaints (even from different customers)?

On what criteria?

It matters.

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[educate889]

I plan to have them use the Customer# as the linking field . . . this will call up all complaints by that cust . . . then QA can pick the complaints they want to group together before giving a disposition (Rework, Return Auth., Scrap, Credit). There really is no criteria other than what they QA director wants to do based on history of their relationship w/ that company complaining.

Just so you know, I have the data right now in 3? tables

tblMaster_CC (all complaints)
tblMaster_QA (all dispostions, inspections)
tblMaster_Log (logs all complaint and who intiatied them)
[don't know if this is needed other than connect other two] I hope the above helps . . . anticipating your response.

 

[Darrylles]

Hi,

Sorry, it's a ball-ache, but I need to know the table structures for the above tables (including customer).

e.g.:

tblMaster_Customer
field1 type
field2 type

etc.

I could guess, but we'd end up going round in circles.

Sorry for delay in responding.

Regards,

Darrylles "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[educate889]

Darrylles -

I will list them . . . but feel free to change as you see fit . .

Master_CC

CC_Item# -> Auto KEY
Job_ID -> Num FK
Log# -> Num FK
Customer_ID -> Num FK
more but unrelated to question

Master_QA

QA_Item# -> Auto KEY
CC_Item# -> Num KEY
more but unrelated to question

Master_Log

Log# -> Auto
Date_Int -> D/T
Int_by ->


I think some of the problem is from the Autonumbers .. . but I need it to be simple enough to give them numbers systematically. (I am trying to institute the AutoNumber
thread 702-433057 to make up for them)

Please feel free to change any of the above in order to be able to fix the above struggles. Or let me know what other ways I could do this.

Thanks again . . .

 

[educate889]

Darrylles-

Still wondering if you could help . . . or anyone else.