In a Novell network I have an application (application 1) in a folder that requires user rights to access.
I have recently created a 2nd application that resides in a folder that is shared by all, no rights assignment required.
I have Name and Address table that has a company name field and a unique company number field. I use the company name/number in a combo field and save the number in the details table. To keep my detail records in alphabetical order by company name I link both tables in a query.
Both application have the need for a Name and Address table that was originally in application 1. When I linked the table application 2, only the user that had rights to application 1 could access the table.
I moved the table to application 2 and linked it to application 1 which appeared to solve the problem.
However, in the forms that use the query that links both tables I am no longer able to edit the table. Removing the Name and Address table from the query fixes the problem but my data is no longer is order by Customer Name. I am however able to add or edit the Name and Address table from application 1.
Any ideas?
I have recently created a 2nd application that resides in a folder that is shared by all, no rights assignment required.
I have Name and Address table that has a company name field and a unique company number field. I use the company name/number in a combo field and save the number in the details table. To keep my detail records in alphabetical order by company name I link both tables in a query.
Both application have the need for a Name and Address table that was originally in application 1. When I linked the table application 2, only the user that had rights to application 1 could access the table.
I moved the table to application 2 and linked it to application 1 which appeared to solve the problem.
However, in the forms that use the query that links both tables I am no longer able to edit the table. Removing the Name and Address table from the query fixes the problem but my data is no longer is order by Customer Name. I am however able to add or edit the Name and Address table from application 1.
Any ideas?
