Hey guys,
I want to create a button when pressed would take me to a form showing the details of the sub-table of the entry currently on screen. i'm sure it's a query.
For example:
I have a table called "Jobs" and it has 3 sub-tables linked to it.
I want to create a form from the table "jobs" and in it a button for each sub-form that would show the details linked to the specific entry currently showing on screen in the "Jobs" form.
What is the query to be created, i know that a sub-form is automatically created when i create a form, but since i have three i don't want anyone to show automatically.
Thanks guys
I want to create a button when pressed would take me to a form showing the details of the sub-table of the entry currently on screen. i'm sure it's a query.
For example:
I have a table called "Jobs" and it has 3 sub-tables linked to it.
I want to create a form from the table "jobs" and in it a button for each sub-form that would show the details linked to the specific entry currently showing on screen in the "Jobs" form.
What is the query to be created, i know that a sub-form is automatically created when i create a form, but since i have three i don't want anyone to show automatically.
Thanks guys