Query on Detail Block 1

[rypper]

I have detail block that has a 1 to 1 relationship with the Master block.
What I'd like to do is query on the Detail block and find the matching Master record.
Master = Empoyees, Detail = SINs.

Thanks for your time in advance.

T.

 

[sem]

I suppose you can not do it when you use Forms native master-detail processing: child query should be in context of parent one. You should implement your own logic. Unfortunately ON-POPULATE-DETAILS doesn't fire if no relations exist, so you should use WHEN-NEW-RECORD-INSTANCE or some other similar trigger.

Regards, Dima

 

[ChrisHunt]

If it's a 1:1 relationship, you could create a view based on the two tables joined together and base a single block on the view - more work, but probably the most efficient solution.

-- Chris Hunt

http://www.extracon.com

http://www.mcgonagall-online.org.uk

http://www.napitalia.org.uk

http://www.leicesteryha.org.uk