filters

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

How does the "filter" work under properties? I have entries being given an
auto-generated ID number from my back-end sytem. I know I need to put
something in this field--how do I do it correctly?

Thank you for any assistance.

LB
 
How does the "filter" work under properties? I have entries being given an
auto-generated ID number from my back-end sytem. I know I need to put
something in this field--how do I do it correctly?

Thank you for any assistance.

LB
Click to expand...

Why do you 'have' to put something in the Filter property?

The filter is used only when you have to display filtered records.
Usually Access itself will take care of that for you.
Open the Form in Form View. Select any field. Click on the 'Filter by
Selection' tool button. Close the form. Open the form in Design view
and read the Filter property. Your selected field is shown.
Regardless of any field shown, the form will not be filtered unless
it's FilterOn property is True.

If you have a specific need to enter a filter, post back with more
information.
 
I believe that I do have to have a filter. I'm mirroring part of the
database created by my co-worker so, I'm basing this on how he did it.

Essentially, I am working with a database of providers. A provider may work
with a vendor--this is that table I've created--vendor information.
Providers and vendors have a many-to-many relationship (some providers work
with the same vendor and they can also work with more than one) so, I have a
table specifically for unique combinations of provider IDs and vendor IDs
(both set as primary keys).

So, as a vendor is entered into the system, they are auto assigned the next
available vendor ID number (this is done by the back-end Oracle system). At
the same time, that vendor ID and the corresponding provider ID are entered
into the joining table.

The reason I feel that I need a filter is because when my co-worker did the
exact same thing with providers and contacts, the filter property on the
contact form reads: [C_ID]=450 (with 450 being either the next available
contact ID if the form is opened blank, or the contact ID of the contact
currently populating the form).

Any additional assistance would be greatly appreciated. Thank you for your
help.

LB
 
Back
Top