Mark N

Where are the "New Millennium" and "Troi" resources? ... and I sure will. Most of the work I have done in the past have been in C, C++ and ObjectiveC so as long as I find good examples and there are good hooks in FM to do this, I should be able to get it done. Mark

Thanks much for your response! I would agree about the Access vs. FileMaker thing. I will try your post on your solution to this issue but it would be much better to have an ideal solution to this. Something that FM should just have but now I'm thinking (due to the fact that FM is so close to what I want for a RAD environment) that I might start looking into the ability to write plugins to FM to facilitate this. I kinda browsed around and have not found much information on writing plugins for FM but I was sure you could do that. If you or anyone else have any links that could point me in the right direction for information about writing plugins for FM and I can get this working, I will post the built plugin back here for everyone else to use. Thanks again, Mark

Hello all. I'm sort of new to FM (used it quite a bit a long time ago). I'm working with FM 7 on a project and want to use a popup to select a value from a foreign table to assign an FK value in the current table. I can get this to work but not cleanly. The example would be say you have two tables, Company which has basic information about a company and a unique key value of type number and a name of type text. The second table is called Contacts with a primary key value as well, a contact name, and an FK (foreign key) value to store the Company key value. Now, I have a popup that allows the selection of a company which currently displays the company key along with the company name when selected. What I need to do is not display just the company name, but yet set the company FK value in the contacts table when the user selected a company from the popup. So far, I have not been able to do this. The best I have been able to do is have the popup display the company key (what I would rather never show to the user) and then a second display field that links to the related company name field. Is there any way to set the contacts FK field via a popup that displays the list of company names stored in the company table without ever showing the company key value? For those familiar with Access, this is done by flagging the key value in the popup as being invisible. Something like this would be perfect. Thanks much, Mark