Hello, i have a table named clients and here in this table i have registered all names for my clients.
i would like when i click on a name from that table to be opened a new table with all invoice or pdf raport only for that client.
Can anyone help me please?
Thank you
No one can help with such things?
Hi
you need to link (application links) the first table (grid) with a new grid or form with invoices
In the second grid (the invoices) include in the SQL statement something like this.
If you use a form, use “where clause” section instead.
select * from invoices
WHERE idclient=[vidclient]
When you create the link from the table of clients to the invoices you can setup the field to pass
regards.