Using Matching records

[woodyinoz]

Thanks for that Lance,

With the matching records I want certain information such as part id, part size, etc.. to be displayed in a tabular form but uneditable (readonly) The only field which I want the user to be able to input and save data in is the final field called "Plate ID". I then want this to be saved in PartReport main table.

Thanks again,

Woody.

 

[almir]

Hello

If I understood you well, you want your users to be able to see certain fields in tabular form, but not to be able to change/update/delete them - except one field.

In Table|Restructure|Passwords menu, set a password for underlying table(s). In right part of window click on appropriate field and in drop-down menu choose access right (full, read-only etc.), respectively, for each field in the table(s).

However, if there are users who are supposed to have different access rights, provide them another (different) password. Define privileges for that/another password in a way that meets users' needs.

Finally, give the first password to the first users group, and the second one to another. Do not forget, if you have not set passwords for your tables yet, the first thing is to define master password, and then the others, hierarchically from top to the bottom. Otherwise, you will have a lot of problems.

Hope this will help

 

[ljprivara]

The way I would handle this is two-fold:

First, create a tableview that displays the matching records. While in design mode, right-click on each field object and select properties. Then select the tab "Run-Time" and make sure that the property tab stop is unchecked. The user will not be able to edit the value appearing in this field at run-time because he or she cannot select it.

Second, you want to make sure that the user can't use a shortcut to go to the underlying master table,which may be the table you don't want certain fields to be edited. While in design mode, right-click on the form. Make sure that you are at the top of the object hierarchy (i.e., #Formdata). Select the tab called "Events", then the action event. You are going to add a line of code that prevents the user from toggeling to the underlying table by hitting "F7". Within the else statement, add the following code:

if eventinfo.id() = DataTableView then
eventinfo.setErrorCode(peCantToggleToTable)
msgStop("TableView", "Sorry, unable to accommodate request." ;
//or some other meaningful response.)
endif