Unable to enter data in a form

[malbreht]

Hi,

I've built a multiple tables form but can't enter any data (tried also with creating a query first and than a form from that query, didn't work as well). Also the little buttons to navigate between records are disabled.

Here's some aditional info about my tables (simplified):

tblCustomer (customer_id, name, mail,...)
/
tblSell (sell_id, date, customer_id)
/
tblSellProduct (sell_id, product_id, quantity)
/
tblProduct (product_id, name, price,...)

And the form I'm having troubles with:
frmSell (sell_id, date, customer_id, name, product_id, name, quantity, price)

Any ideas? Do you need any extra data?

Thank you very much!

 

[fneily]

See:
Harnessing the Power of Updatable Queries

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccess/html/msdn_harness.asp

 

[Pampers]

To check if the query is updatable, look at the record navigator and see if the new record sign (*) is enabled (black) or disabled (gray). If gray, not updatable, then you need to have a look at fneilly's reference...

Pampers
Keeping it simple can be complicated

 

[malbreht]

Tnx, will check...hope to find the answer in that long article

 

[malbreht]

Have read the whole article, have looked up the sql code behind the query...but still can't fix the problem. I also changed the tables, so that no data is obligatory, but there's still no result. Can anyone help me? Here's the sql code:

SELECT tblSell.Sell_ID, tblSell.Date, tblSell.Customer_ID, tblCustomer.Customer_ID,  tblCustomer.Name, tblCustomer.ContoNumber,  tblProduct.Product_ID, tblProduct.Name, tblProduct.UnitOfMeasurement_ID, tblSellProduct.Quantity, tblProduct.Price
FROM (tblCustomer 
INNER JOIN tblSell 
ON tblCustomer.Customer_ID=tblSell.Customer_ID) 
INNER JOIN (tblProduct 
INNER JOIN tblSellProduct 
ON tblProduct.Product_ID=tblSellProduct.Product_ID) 
ON tblSell.Sell_ID=tblSellProduct.Sell_ID;

Many, many thanks to all!

 

[malbreht]

I managed to find out what was wrong by myself and I would like to share that with the rest of the "newbies" like me:

Be careful by defining possible Indexation when dealing with foreign keys. You can't obviously set Indexation to Yes with doubled data to be disabled. You can do that only for Primary keys and for fields that are not keys at all.

At least that was the case by me.