dottie, I didn't explain the why you can't do this.
When you add a field to a existing table there is no way for us to figure out where on the screen you want that field to go so we may mess up an existing screen. It may be a required field which would further complicate automatically adding a field. The only option we provide for automatically adding a new field is when you're creating a brand new screen - a new screen allows us to determine the placement and function of everything for you.
However, after I add the field it does not offer me the option to enter what I want my drop downs to be. This might be a separate issue of what Im trying to do.
If the new field you're trying to add is a dropdown select dropdown from the field type list and click add field. You'll get a popup window and be prompted to either create a new table or choose from an existing table.
What I want to do is plug this info into the main screen in my Customer/Contact list so I can filter the jobs by job status and it must match the info coming from inside the customer as it updates when needed.
You'll need to make a copy of the CRM_CustomerList screen and edit the grid to add a column for job status. Here are the steps to acheive this ...
First you'll need to add the JobStatus field into the Contacts table since it's not there by default (and the CRM_CustomerList screen is based off the Contacts table)
- Click Customize > Tables / Fields
- Click Contacts.
- Select Add a Linked Field and link using Entity and the linked field you want is JobStatus.
- Click Add Field.
- Click Finished Editing Fields.
Second you'll need to customize the CRM_CustomerList screen...
- Click Customize > Screens.
- Find CRM_CustomerList and rollover it to display the Copy button. Click Copy.
- Step 1, copy from this account.
- Step 2, rename it if you like.
- Step 3 is very important - select the last option, Add a tab link. From the drop down you'll probably want to add it to the tab Customers.
- Once that finishes find your newly copied screen and click Edit.
- Look for the Contacts grid and click the little Edit button on the object.
- Click Next on step 1.
- On step 2 you want to add a new column and select the field JobStatus.
- Click Finish.
- Click Publish then click Save & Close.
This should give you a great head start with customization. You've linked a field from one table to another, copied a stock screen and edited a grid. If you have any questions please post back. We're here to help.
~C