Hi,
I came across Alpha 5 help on:
Filter Expression Dialog Box
The Filter Expression dialog allows you to specify an association between the current table and the lookup table. A typical circumstance when this would be desirable is when you selected a value in a vendor field and wanted the list that appeared in the product field to contain only the vendor's products.
This is exactly what I wanted for a project I am working on. In our database, we have a table for swimming_pool_owners and one for the Pool_shops that the pool owner's water sample is submitted for analysis and a table for analysis results. In the swimming_pool_owners table, we have a field for Poolshop lookup (PSID). We have also created a set to link analysis table (Parent) to Swimming_pool-Owners (child).
We created a form for the analysis_pool_owner_set. In the form for analysis result, PoolOwner will be filtered by the value in the Poolshop field.
I created a form for the Analysis_PoolOwner_set, on the Po_Name field, under properties, Setup tab, I choose <Record list box> and then I am lost in the <Choice tab>.
What should I put in for the expression in Current table, target table?
I had uploaded the database. Your help would be most appreciated.
Con
I came across Alpha 5 help on:
Filter Expression Dialog Box
The Filter Expression dialog allows you to specify an association between the current table and the lookup table. A typical circumstance when this would be desirable is when you selected a value in a vendor field and wanted the list that appeared in the product field to contain only the vendor's products.
This is exactly what I wanted for a project I am working on. In our database, we have a table for swimming_pool_owners and one for the Pool_shops that the pool owner's water sample is submitted for analysis and a table for analysis results. In the swimming_pool_owners table, we have a field for Poolshop lookup (PSID). We have also created a set to link analysis table (Parent) to Swimming_pool-Owners (child).
We created a form for the analysis_pool_owner_set. In the form for analysis result, PoolOwner will be filtered by the value in the Poolshop field.
I created a form for the Analysis_PoolOwner_set, on the Po_Name field, under properties, Setup tab, I choose <Record list box> and then I am lost in the <Choice tab>.
What should I put in for the expression in Current table, target table?
I had uploaded the database. Your help would be most appreciated.
Con
Comment