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
Column/Type
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.
Thank you 
Thisis another post on this issue, but with no solution: Problem with edit link in select field - Scriptcase 9 / General - Scriptcase