KevinRan

LaRetta, It works. Many thanks. Kevin

Thanks LaRetta, My boss just walked in and dumped a ton of other work on me. I will have to try your suggestion next week. I appreciate the response. Have a great weekend. Kevin

LaRetta, The calc you listed above seems like something I was looking for. I am trying to show all records and if a particular field is empty I want to automatically delete that record. Would the calculation you listed above work for me? If so, how would I finish it? I've tried a few different ways with no results. (Ditto what SharonK said) Thanks, Kevin

Soren, Thank you very much. My brain was on the wrong path. These steps work perfectly for me. Kevin

Raz, I got the relationship to work by using the "X" type you suggested. I used it in a portal instead of the list you suggested. The list worked fine on my first try, however I already had a design of multiple layouts and the list didn't fit in aesthetically. I had to mess around with the button behavior a bit until I got it to show the related fields. I couldn't have done it without your help. Thanks again, Kevin

Hi, Does anyone know of a way to program a button to behave the same way as the hitting the Return or Enter Key. I have a Find function in a layout and I have the status box closed so users can't see it. Once they enter the criteria into the field for the search I want them to click a button to initiate the search. (Most of the users in this place won't know to just hit the Enter key on their own.) I want this button to be the equivalent of hitting the Enter Key. Any help is greatly appreciated. Thanks, Kevin

Thanks Raz, I'm off early today for the holiday, back on Wednesday. I'll try out your suggestions then. Have a great 4th. Kevin

K1200, Thanks for the info. However I'm still having trouble. Your item #4 says "displaying only the customer names from your original table." Do you mean when I insert the portal it should be "Show Related Records from original table" and then add field Customer Name from original table? If so, when I create the portal, the original table name is grayed out and I'm only allowed to use related records from the CurrentRecord T.O. Can you tell what I'm doing wrong? Thanks, Kevin

Hi, I'm a newbie. I thought this problem would be easy to solve for me but I was wrong. I have a table that contains- RecordID, CustName, UserName, Password. I want a layout that would show a list on the left side of the layout containing all CustNames (with scrollbar), a user could click on a name in the list and the Username and Password for that record would show up in two fields on right side of the layout. Can anyone start me off in the right direction? Thanks, Kevin

I got the flag to work fine. I have learned a lot in the process. Thanks for your help. Now on to my next project. I have to create an estimating program for our company. I love this stuff! Kevin

Lee, Thanks again. Your samples are great. I think I'll have time to work with this one today. I'll let you know how it goes. You have really helped me learn alot! Kevin

Hi again, I got the function to work fine with just one checkbox. Is it possible to make the flag appear when the field refers to a value list containing more than one item? I messed around with it and was unable to make it happen with more than one. Thanks, Kevin

Thanks Lee, I've been working all morning on the concept and haven't figured it out. Now that I have your example I think I'll have better luck. I really appreciate the help.

Thanks Lee, I'll give it a try. However, I don't see the attachment you're referring to. -Kevin

I work for a printer. I have a database that tracks the print jobs that come into our office. I'm trying to figure out a way to get some kind of flag (like a large red square) to appear in the layout if a particular check box or radio button field is selected. The scenario is this, I want something bright to indicate this client ordered a proof sent to him before we print the job. An ordinary check box is missed too easily. Thanks in advance, Kevin