Hi,
I’m trying to build a simple database with two tables. Table 1 is a master report, which I export to a word document, a table 2, a large library/template from which I hope to copy records to table 1 to build a report.
Table 1 and 2 contain the same fields ‘element’ [e.g. roof, ceiling, floor etc], ‘item’ [a description], ‘works’, ‘task’, ‘priority’.
I have been able to use DB Popup successfully, and been able to group, so I can pull in the records from table 2 to table 1 once selected.
The problem is table 2 is huge, and impractical to find the records, so I want to create a form which allows me to select ‘element’ and then filters the possible records from table 2 to allow me to copy to table 1.
How do I get a filter to apply based on the element?
Any help will be apprecited.
I didn't find the right solution from the Internet.
References:
http://www.ddhsoftware.com/forum/viewtopic.php?p=18616
Video marketing agency
Thank you.
I’m trying to build a simple database with two tables. Table 1 is a master report, which I export to a word document, a table 2, a large library/template from which I hope to copy records to table 1 to build a report.
Table 1 and 2 contain the same fields ‘element’ [e.g. roof, ceiling, floor etc], ‘item’ [a description], ‘works’, ‘task’, ‘priority’.
I have been able to use DB Popup successfully, and been able to group, so I can pull in the records from table 2 to table 1 once selected.
The problem is table 2 is huge, and impractical to find the records, so I want to create a form which allows me to select ‘element’ and then filters the possible records from table 2 to allow me to copy to table 1.
How do I get a filter to apply based on the element?
Any help will be apprecited.
I didn't find the right solution from the Internet.
References:
http://www.ddhsoftware.com/forum/viewtopic.php?p=18616
Video marketing agency
Thank you.
Comment