Rabu, 29 Juni 2011

[MS_AccessPros] Linking several fields in a form.

 

Hi everyone! I'm new on this forum, and this is my first post :).

I have a Database that has a column of Shops, another one of Banks that operate through that shop and other data as Sales, Date, Number of Clients.
I have a Shop catalog, a Bank catalog, a Banks and Shops they work with Catalog. They are all properly related with the Database.

Each Shop works with different Banks, and each Bank works with different shops.

I made a Form for each Shop that has a Subform (#1) that lists the Banks that work with it.
And I made another form (#2) that lists Shops, Banks, Date, Sales, and Clients.

I want to introduce this last form (#2) as a subform, that shows the Date, Sales and Clients for the Shop AND for the Bank that I click on the subform of banks.

I know how to link the subform to each Shop, but it shows me all the banks.
And I know how to link the subform to each Bank, but it shows me all the Shops.
And Access only allows me to link one main and secondary variable on the Property tab of the subform.
Is there any way of linking both of this fields to my subform?

What I want is more less like this:

(FORM) SHOP A

Banks that Operate with this Shop
(Subform1) | BANK A | <---If i click BANK A.
| BANK B |

History by Bank for this Shop
(Subform2) |SHOP BANK DATE SALES CLIENTS|
----------------------------------------
| A BANK A X1 Y1 Z1|
| A BANK A X2 Y2 Z2|
| A BANK A X3 Y3 Z3|
| A BANK A X4 Y4 Z4|

This subform only shows the results for this
Shop, and for the Bank I clicked on Subform1.

Thank you for your time!


__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar