>Next Question -
>What’s the best way to limit data access depending on First 2 char?
>All P<--->>C keys (CC9999) start with
>‘MD’
>‘ST’ or
>‘TD’
>no filter for top management - AS IS would be fine!
>Maintaining about 1650 recs having 126 fields combined (includes 2 Memo).
>
>A) Create index filtered on both parent and child & use as relation.
>
>B) Delete DBC Relation and Create 3 View with it’s own D E.
>
>C) Create 3 Form’s (ignoring DBC relation) having own relation’s.
>
>D) A better way not mentioned above?
>Should I be starting a new thread for each question?
>Thanx - Ed B

A NO, I dislike filtered indexes because you need different indexes for each filter.

B Close (see D below)

C NO Too much overhead

D Use a parameterized view, where the parameter is the 2-char information. There are threads about parameterized views. If you haven't used one, then it's just a standard view, except in the WHERE clause you put a question mark in front of the variable on the right "WHERE Myfield = ?Myvar" When you load the view, if the program can't find MyVar it will ask you. Usually you set this value programatically. You WILL need an index on the field.

As for new threads, play it by ear. It's sometimes easier to follow several short threads if the topics are different. If it's more questions on the original topic, just extend the present thread.

HTH
Barbara