I have 2 tables
table 1 has fieldid1
table 2 has fieldid1 and fieldid2
table 1 has a many to 1 relation to table 2 through fieldid1
whenever I bring up a certain table form for table 1, I only want to see the records where table 2.fieldid2 = 1
I already have a self join on table 2 for fieldsid2=1
where/how do I set up this filter.
Sarar,
You can add a condition with a literal value in the relation editor.
In the left column you type 1 and in the right column select column fieldid2.
Rob
hi Rob,
I already created a relation from table 1 to table 2 using fieldi 1 as a link and then added the condition for field2 = 1 in a second line of the relation
but
How do I now tell the form for table 1 to only show records based on this relation. Where am i indicating the relation.
Make sure your relation is an Inner join instead of left join. Then find or sort by a field in table2 (through the relation). That omits records with no related record in table 2.
Alternatively, base your form on table 2 and show related fields from table 1. So table2 controls the record set.