This topic is locked

Joining 2 tables in a view

7/10/2011 1:04:01 PM
PHPRunner General questions
A
ant author

I am having a simple problem in joining 2 tables in a view and then editing the fields in both tables.
The 2 tables are customer and leads and the relationship is one too many. I want to add the customer name to the lead and then create a view which shows info from both tables which I can edit together. I am doing something wrong because I get a an error message

<<< Record was NOT edited >>>

Unknown column 'customers.Customers' in 'field list'
Please can someone assist.

C
cgphp 7/10/2011

To say what's happening we need more info such as source code, sql query, code and original error message.