488587 microsoft access- relationship between subforms

Hello I have a sample db attached- microsoft accesss

main form- 3 subforms

if you open database a form opens:

*this may be not able to do -or hard*

enter 111 in serial number

select 159355 in item number

enter 1111111 in SO number

The two subforms on the right - i am concerned with

The top right subform labeled 'installed parts'?

it is working good- only SO number 1111111 and p/n 159355 display

The bottom lower right hand subform labeled 'repair history'

is not working good.

i want to only see SO number 1111111 and Part_number 159355

If you notice it displays 1591

my question:

can you make that subform only display so number 1111111 and Part_number 159355?

right now it is joining on SO number - but displays all Part_Numbers

Thank you

Beceriler: Her şey Kabul, Microsoft, Microsoft Access

Daha fazlasını gör: parts database access, microsoft number, microsoft access parts database, access parts database, access subform, microsoft, access microsoft, item serial number, repair form database, database relationship, open access, good access, serial access, working relationship, make database access, display form access database form, access db sample database, access db sample, parts microsoft access, serial number database, access number, access database serial, database microsoft access, access sample database, hand history database

İşveren Hakkında:
( 49 değerlendirme ) indianappolis, United States

Proje NO: #2234498



I can do finish this work. Kindly check your PM.

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(30 Değerlendirme)