2. PHPRunner General questions
  3. Is it possible?
This topic is locked

Is it possible?

 		3/20/2007 09:02:56
PHPRunner General questions
M
 mylandrover90 author

Hi there.
I have been using PHPRunner for a while now and it has done everything I have wanted, but now I am trying to push it.
I am wondering if the following is possible...?
Is it possible for a User to log in to the system, edit a record that has been previously created and add a new field, say a latest progress report on a customer that he has phoned.
My way of thinking is a button at the bottom that he can click to 'Add new report'. This needs to be done an unlimited amount of times and will have a date stamp to make sure it is unique.
I think I am asking for trouble and will accept 'NO' as an answer.
I am able to create the database in Access and/or MyPHP if it is of any help.
Many thanks for any advice you can give.
MyLandRover90
J
 		Jane 3/21/2007

Hi,
I recommend you to use master-detail relationship for this project.
For example, create two tables Users and Comments in your database and set up Users table as master for Comments table. Then choose User can see and edit their own records only option and select correct fields in both Users Table: OwnerID and Main Table: OwnerID dropdown boxes on the Advanced security settings dialog on the Security tab.
If you'll have difficulties with security settings you can publish your project on Demo Account and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] a URL to your pages and I'll help you.
M
 		mylandrover90 author 3/23/2007

Hi Jane,
I have followed your guide and have produced the solution.
Many thanks.
M
 		mylandrover90 author 3/29/2007

Hi Jane.
I am having great trouble with my Project.
::Web details sent to you on PM::
I am using 1 Master table (Customers) and 3 Detail tables (Appointments, Comments and Product Demo).
I also use a Users table with a First Name=username and Last Name=password.
Each User has a unique Sales ID which is on all tables and security setting segregates the users and the information they can access.
I have linked them using the Primary Key of Company Name.
All tables have a Key Column of Customer ID No.
All seems to be in full working order and I have even changed the Company Name field to be Read Only on the detail tables.
I can happily enter data on the system on all tables but when I try to view the entered details it's blank.
I can see the entered data on the Access Database itself so I know it's saving correctly apart from not entering the Company ID No.
I have tried to change the Primary key to Customer ID No. but after entering the data on the detail table (comments for example) I get a PHP Error Of the following.
Error Type: 2

Error description: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect

URL: www.gatwickdistribution.co.uk/log/Comments_list.php?a=return

Error file: C:\Program Files\xampp\htdocs\zencart\log\include\dbconnection.php

Error line: 30

SQL query: select top 50 [Company ID No], [Company Name], [Sales ID], [Comment], [Date] From [Comments] where ([Comments].[Sales ID]='CW') and ([Comments].[Company ID No]='86')
Please can you advise.
Many thanks.
MyLandRover90
Sergey Kornilov admin 4/4/2007

You need to post your application to Demo Account and send the URL to support@xlinesoft.com.