I think, from all the advice i'm being given, that i'm trying to approach this the wrong way. Unfortunately i haven't been able to figure out the right way so i'm going to try to reframe my question...
What would you say is the best way to approach the following?
I want a form which allows data entry into a main table but also displays a list of records filtered from the same table. There is also an additional, calculated field displayed with the list.
The filter criteria are a date and a name, a list of which are in a separate table.They are separate fields for first and last name but i would like to filter with both and display them concatenated in the list.
Any guidance would be greatly appreciated!
What would you say is the best way to approach the following?
I want a form which allows data entry into a main table but also displays a list of records filtered from the same table. There is also an additional, calculated field displayed with the list.
The filter criteria are a date and a name, a list of which are in a separate table.They are separate fields for first and last name but i would like to filter with both and display them concatenated in the list.
Any guidance would be greatly appreciated!
We'll help you *manage* it if you like that approach and want to use it. And, yes, that would be the reason for putting it in the Form Header (or Footer for that matter, if using a fixed Form size).
