I need to link my SINGLE order form to a SINGLE customer form with FK customer_id as a SELECT field, this to be able to edit old customers and create new customers from the selection field on the order form.
First Table : tbl_0_bookings
bookings_id int(11) Auto Increment
customer_id int(11) NULL
Indexes PRIMARY bookings_id INDEX customer_id Foreign keys Source / Target / ON DELETE / ON UPDATE customer_id tbl_0_customer(customer_id) RESTRICT RESTRICT
Second Table: tbl_0_customer
Column / Type customer_id int(11) Auto Increment customer_name varchar(255) NULL Indexes PRIMARY customer_id
My SQL select statement is on the customer form following:
SELECT customer_id, customer_name FROM tbl_0_customer ORDER BY customer_name
When I click on “create link” and connect to the individual customer form, I get the following message when I have added the WHERE clause “customer_id = [customer_id]” to the SQL statement in the customer form:
And when I click on “create link” and connect to the individual customer form, I get the following message when the WHERE clause is empty:
I think this should be right out of the box, but I cant find any solution to the problem in manuals, videos and here, so I will really appreciate some help on this issue.
Thisis another post on this issue, but with no solution: Problem with edit link in select field - Scriptcase 9 / General - Scriptcase