M
Mishanya
I have tblPackages:
1) PackageID - unuque index
2) ClientID (cbo with ClientID and ClientName based on tblCLients )
3) ProductID (cbo with ProductID and ProductName based on tblProducts)
4-14) A few fields with package-related info.
The table determines how the clients want the product to be packed for
delivery.
Every client may have predisigned package for each product or for just a few
of them. I.e. if there are 10 clients and 10 products, then there are up to
100 package IDs (up to 10 for every client).
I want to create a form with cboClients ,cboProducts and all the
package-info (items 4-14 from the tblPackages), where first I choose a
ClientName from cboClients (wich filters cboProducts down to the list of
products the client has predisigned package for), then I choose a ProductName
- and all the package-info is presented.
So far I can create a form for inputting the data in the tblPackages and
then view the records by paging. But I need to have a form with comfortable
approach directly to the wanted package with only view option (no adding or
changing data).
I've already learned how to filter one Combo based on other.
Please help with designing this kind of form.
1) PackageID - unuque index
2) ClientID (cbo with ClientID and ClientName based on tblCLients )
3) ProductID (cbo with ProductID and ProductName based on tblProducts)
4-14) A few fields with package-related info.
The table determines how the clients want the product to be packed for
delivery.
Every client may have predisigned package for each product or for just a few
of them. I.e. if there are 10 clients and 10 products, then there are up to
100 package IDs (up to 10 for every client).
I want to create a form with cboClients ,cboProducts and all the
package-info (items 4-14 from the tblPackages), where first I choose a
ClientName from cboClients (wich filters cboProducts down to the list of
products the client has predisigned package for), then I choose a ProductName
- and all the package-info is presented.
So far I can create a form for inputting the data in the tblPackages and
then view the records by paging. But I need to have a form with comfortable
approach directly to the wanted package with only view option (no adding or
changing data).
I've already learned how to filter one Combo based on other.
Please help with designing this kind of form.