I need help.
I have a table with many records (and many fields too) and I need to create a report for ONE record only, right now whenever I add a field its adding ALL records pertaining to that field.
I already made the input form (which i think is basic but its working at least.)
I need a way to choose a specific record by filtering it from TWO fields which produce a unique record.
By querying the TWO fields I will get a unique result. For example: i have Name and Date. There can be more than one name per date and vice versa but ONE name will have only ONE unique date.
So I can have name: Germany and France to Jan 15th 2010, and I can have Germany to Jan 15th and Jan 20th, but by choosing both Germany and Jan 15th I get only ONE possible record as Germany can't have more than one Jan 15th.
How do I filter based on the criteria above and NOT by the record ID, so that I can create a report by choosing Name and then it filters to the Dates of that particular Name, then I would choose the Date (which would be maximum of two but usually one) and then create a report for the corresponding record, which will have to be unique.
Then I want to be able to click a button on my form AFTER i have inputted the fields and be able to view this particular record that I just entered as a form.