Please help, have no clue!?!?

[Superock]

I have created a relational dB (picture included of layout). When I try and create a query and include tblAssets and two or more tables that is in a one-many relationship with tblAssets linked by the AssetId field I can not update any records in the query, wheter it is through a form or query.

I have no idea why this is happening, I am suspecting that I can not/should not be creating multipule tables in a one to many relationship with the same key?

 

[pbaldy]

This has information on what will make a query read-only:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

 

[Superock]

I get it now..

Thx for the info, this does pose a slight problem for me though. I hope that perhaps there may be a solution other than creating a form with multipule subforms.

I started creating the dB from a .xls flat file. For data input purposes and familiarity on the client side I wanted to present the data in a format that they are used to seeing. I am still at the begining stages of the design and am more than willing to make relational changes in order to achieve this goal, if however this just does not make sense then I will go ahead and follow your advice and create main form with multipule subs.