Add form problem

[fuzzyq]

Hi,
I'm new here.

I create browse form and i inner join two tables on this form.
When i create object text and add this object to my form and try add some record program give me error:

Code: Select all

An error has occurred while running this query.

SQL

SELECT * FROM `model` WHERE `model.id` = '-1'

and this is my browse html:

Code: Select all

select * from model
inner join marka on marka.id = model.marka_id

plz help me.

Regards!

ps. sorry for my bad english.

[admin]

fuzzq,

Make the primary key of the Form id not model.id.

Steven

[painatal]

i've had the same problem. did you solve it?

[admin]

painatal,

This is the answer

Make the primary key of the Form id not model.id.

Because nuBuilder puts 2 ` around the primary key.

Steven