Topic: Best way to create a search using data from , and data to.
Hey everybody, i want to make a search , so i can search the invoices from a specific date, "From" and "To"
But here's the catch:
The Table that has the invoices, doesn't hold any Dates, it has an ID to yet another table, and this second table has the dates i need.
Example
Table 1
ID_Table2
Invoice Description
Prices
Etc...
Table 2
Something...
Something...
Dates <----
Something...
ID_Table1
Goal:
To search Table 1 , All Entries that have specific Table2_Dates