Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

master detail one to one relationship

Status
Not open for further replies.

Apprentice101

IS-IT--Management
Aug 16, 2004
66
US
on a master detail selection, how can I enforce the detail secction to have only one row.

I curently have the detail to display one record only,but if the user hits the navigate button, it navigates into a new detail record which I dont want.

I other words, how can I enforce a one to one relationship?

thanks!
 
What do you mean if the user hits the navigate button. Do you mean hits the down arrow or page down key? If so you can trap these key strokes and code a null; statement on the trigger.
 
yeah, that is exactly what I mean, I didnt want the user to navigate to the next record.

can you please give and example for how to code the null statement for this?

Thanks Tom.

joey
 
Just create a new block trigger. For example the "key-down" trigger. Then when the code window pops-up just put the following statement in:-

null;


Thats it!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top