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

Re: Best way to create a search using data from , and data to.

Hello.


I think it's not problem, just set up button with action "Search" and use two components DateTimePicker, one with property Fillter= >=, and second, Filter= <=



Also I see that you have ID_Table1 and ID_Table2, it's mistake, you should have just one relationship between tables.

Dmitry.

Re: Best way to create a search using data from , and data to.

Hey Dmitry, yes you are right, i have both relationships between tables, but table_1 doesn't even have any records for ID_Table2 .

OKay so here's my problem:

I have Table_Prices with various lines, each line corresponds to a  Table_Customer ID:

Line1 -     ID_Table_Customer         Price       Description Etc...

While Table_Customer i have

Name  Description Date etc... but no id relative to Table_prices because i have multiple lines to a single customer.

Is there a way to search for those lines in ID_Table_Prices using the date from Table_Customer?

Re: Best way to create a search using data from , and data to.

attach your project