Hi all,

I have the below requirement, can anyone help me to achieve this ?

1. I have a table company, which contains fields: company name & company id.

2. I have a another table with fields: employee id, name, company name & company id.

3. I have created a relationship between company & employee using company id field

My question is,

1. I have to provide a drop down to show list of company names to reference to the company field in employee

2. Once the user selected a company name. I need to show the information related to company using company id field in employee

3. If someone change company name in company table then that has to be updated automatically in the employee table

Could you please help me to achieve the above requirement ?

Thanks in advance.

Thanks & Best Regards

Hari

Does this help?

Company_Contacts.zip

Excellent! Thank you. It does.

I have another one clarification, Is it possible to use only one field instead of two fields ?

Currently, we are using two fields, one field for company id (like company id drop down in contacts). After the selection, we are displaying the company name in the separate field. Is it possible to use a same field for both purpose ?

Thanks in Advance

Hari

Edited October 1, 200817 yr by Guest

Hi Hari:

I've been traveling the last 2 weeks and just got back. Take a look at this and let me know if it accomplishes your goal.

It is accomplished with a little slight of hand. Both fields are on the layout, but, you only see the name field.

Look at the Contacts layout for an explanation. If you need anything more let us know.

hth

Show_only_Company_Name.zip

Thank you very much. Excellent!

This is the solution I expected

Hari

Hello,

I have the below doubt:

I have an application. Which I want to send to my client as a deployed application. I can able to create deployed

application easliy. But, it contains the framework top menu with the application. I can able to resize the window

which is below the framework. But I cant able to resize the framework window.

Can you help me ?

I attached an image for your perusal.

Thank you - Hari

Edited October 17, 200817 yr by Guest

Hi,

Please do not double post. FM Forums prefers if you just post in one place (choosing the best to fit your question). Most of the Developers here review all forums anyway and will surely see your post. I have deleted your other one. Thank you! :smile2:

The tools you need to review are custom menus and turning toolbars off. You may also explore kiosk mode for the runtime.