Show All Records For Given Field Filter In Access 2010 Table -

hopefully make sense...i have table in access 2010 contains list of suppliers , point of contacts @ supplier , work. pocs vary in number, anywhere 1-4 point. table set each poc on separate line.

the supplier have 1 contact work have 3 different contacts , vice versa.

what want happen when select value combobox on form, related pocs need shown instead of cycling through them 1 one.

for example, supplier1 has 2 pocs @ facility , have 3 @ our facility. have combobox find supplier1 in table , show contacts supplier (their facility , ours) in textbox.

the user able edit contact information and, if not difficult, able add/delete contact.

i'm sure question similar 1 has been asked before, have been unable word correctly find solution through google searches/this website. i'm comfortable enough vba use if required no means expert. unfamiliar sql , avoid going direction if @ possible.

i have careful data provide can if need see data or that.

supplier    code    part    supplier contact   procurement contact  qc contact ajin        akvn            patrick                 yong                 jack    ajin        akvn            chase                   yong                 jack    autoliv     amnp   seatbelt daryl                   james                lewis   bosch       ag48            hancheul                kevin            carlex      akj5  qtr glasses  bob                  joy                   zack   continental ankc            jacob            ksr       c03a05 brake pedal jose                   paul                 david ksr       c03a05 brake pedal jose                  paul                  gary ksr      c03a05  brake pedal jose                  paul                  steven ksr      ag5z   accelerator pedal jack             paul                  david ksr      ag5z   accelerator pedal jack             paul                  gary ksr     ag5z    accelerator pedal jack             paul                 steven ksr     ag5z    accelerator pedal cory             paul                 david ksr     ag5z    accelerator pedal cory             paul                 gary ksr     ag5z    accelerator pedal cory             paul                 steven 

your table needs heavy normalization (see e.g. what normalisation (or normalization)? or http://r937.com/relational.html )

i suggest (note: i'm not sure supplier/code/part relation) :

- tsupplier supplierid   suppliername 1            ajin 2            ksr  - tparts partid     supplierid   code      part 1          1            akvn 2          2            c03a05    brake pedal   - tcontacttypes typeid    type 1         supplier  2         procurement  3         qc  - tcontacts contactid  supplierid  typeid  contactname 1          1           1       patrick 2          1           1       chase 3          1           2       yong 4          1           3       jack 

and on. first column of each table primary key, autonumber field. other id columns foreign keys, linking parent table.

now can have combobox supplier, gives supplierid.
that, can filter contacts , show them in datasheet subform.
either in 1 table, contacttypes column, or in 3 subforms, each filtered 1 contacttype.

to able add new contacts, use beforeinsert event assign current supplierid.