Hi
This is really my first experiment with A5.
I imported some data from another database ...went fine.
I created a form, called frmJobs_review.
Onto that form I dropped a ComboBox and made it so it displays a list of Job Numbers. on its
I then created an action called :Open Default Form or Browse
On "Layout Name" I chose Browse.
On 'Advanced' tab I accepted the default Pointer called varP_frmJobs_review.
Then I selected:
'Records that match the value in a control on the current Form or Report'
and under Filter: I selected..
Value in field = 'Job Number'
and under 'matches the value in the control': Dropdown 1 (the combobox on the form).
I figured that when I selct a job number from the combobox a browse would pop up , showing all the fields from that particular job, instead I keep on getting a messagebox popping up saying "No records in query". Yet there have to be records as there would not be a Serial number in the jobs table unless it has had a job on it.
Also whenever I go to the combobox properties it keeps saying under the Field Description, Field..."Missing or invalid Keyword" yet A5 has generated every bit of writing in the properties box?
Editing as I just noticed the same thing occuring when I open the AlphaSports database and right click and look at the properties for any control on the form in design mode. I'm using 1772:3208.
Thanks for any assistance
Mike
This is really my first experiment with A5.
I imported some data from another database ...went fine.
I created a form, called frmJobs_review.
Onto that form I dropped a ComboBox and made it so it displays a list of Job Numbers. on its
I then created an action called :Open Default Form or Browse
On "Layout Name" I chose Browse.
On 'Advanced' tab I accepted the default Pointer called varP_frmJobs_review.
Then I selected:
'Records that match the value in a control on the current Form or Report'
and under Filter: I selected..
Value in field = 'Job Number'
and under 'matches the value in the control': Dropdown 1 (the combobox on the form).
I figured that when I selct a job number from the combobox a browse would pop up , showing all the fields from that particular job, instead I keep on getting a messagebox popping up saying "No records in query". Yet there have to be records as there would not be a Serial number in the jobs table unless it has had a job on it.
Also whenever I go to the combobox properties it keeps saying under the Field Description, Field..."Missing or invalid Keyword" yet A5 has generated every bit of writing in the properties box?
Editing as I just noticed the same thing occuring when I open the AlphaSports database and right click and look at the properties for any control on the form in design mode. I'm using 1772:3208.
Thanks for any assistance
Mike
Comment