Questions A Bundled

[TWIRED]

1) How Can I Change the Default "View Details" link to just "Details"?

 

2) Grid Edit - How Can I Make the tables NOT shrink and get squishy when I Click "Grid Edit" 

Attached Images Below

 

 

3) How Can I do the following WITHOUT Creating 3 DataPages

 

Tbl_CompanyInfo    Table 1 - Autonumber/Unique    - CompanyInfoID

Tbl_EmployeeInfo   Table 2 - Autonumber/Unique    - EmployeeInfoID

 

Relationship of Tables  : 1 Company >> Many Employees

 

Step 1

Single Form  - Company Info & EmployeeInfo (Virtual Fields) is filled in (generates CompanyInfoID in Tbl_CompanyInfo)

pass hidden EmployeeInfo parameters to Hidden Form 2 

 

Step 2 (Hidden/Autosubmit/ Javascript Data Page)

Form 2 - Employee Info - Is Filled In with passed parameters & auto JS submitted (generates EmployeeID in Tbl_EmployeeInfo)

 

Completed Forms 

 

Step 3 

Need to place : Newly minted EmployeeID into Tbl_CompanyInfo Table

*Without a hidden/autosubmit/javascript  Data Page !

[MayMusic]

1) How Can I Change the Default "View Details" link to just "Details"?

 A: Edit the localization you are using for this page, under Results Pages >> Record Actions >> Element find view details and change the custom text

 

2) Grid Edit - How Can I Make the tables NOT shrink and get squishy when I Click "Grid Edit" :

A: Add Header to "Configure Result Page Fields" screen and use the code below:

<style>
.cbGridCtnr, .BodyCtnr, .Table {
width: 100% !important;
}
</style>

[MayMusic]

Regarding your third question what is the relationship between company and employee table? which one of the following:

 

1 Employee ==> Many Company

Many Employee ==> 1 Company

Many Employee ==> Many Company

[TWIRED]

Thanks May for your help.

 

The Relationship we've chosen (not by choice ) is

1 Company  >> Many Employees 

 

- Weve chosen this model,

Due to the limitation of :

updating just 1 table at a time and no sql/stored procedures permitted

which  would generate many many data pages and would be undesirable .

 

Our new application is a full tiered app that would include

Web & Legacy Customers, Companies, Employees .

 

If theres something Im missing on how to achieve many to many table relationships without creating multiple hidden javascript pages which would  create a  page sprawl, please do educate and enlighten me.

 

It would help a lot.

Thanks !!

[TWIRED]

Also.. The code worked for the grid edit tool, Thanks

But the columns are unevenly spaced and some of the columns cant be read properly.

Is it possible to spread it out evenly.

 

Attached Pic

 

Thanks~

[MayMusic]

For the many to many you have to break it down to two one to many relations so you need to have an extra submission page to add to this join table.

 

As for the Grid, if possible give me the URL to take a look. Probably you need to check and see if you have a fixed width for some columns in your report