Recent content by shreyans.ghia

Well.. I have found an alternate solution to my problem. Although I wasn't able to run the update query, what I have done is Joined my 2 tables i.e. [Order Details] and [Purchase Order Details] using LEFT JOIN and then executed a "Make Table" query. This way I was able to get what I wanted...

Yes I did try the one given by you as well. Cant figure out whats wrong with that.

Actually I tried this earlier as well, it doesn't work. It gives an error "Enter Parameter Value" for "Purchase_Order_Details.Purchase Order #"

Thanks a lot for your detailed explanation. This should work now.

I have no idea why it still doesnt work... i am really sorry , I am new to this ..although I did zip it before pasting the link.

Oh sorry , the image didnt come... I'll try again.

Dear Paul, The thing is I had to modify the entire structure of my database to incorporate certain changes. So now the way this is structured is 1 Work Order can have multiple Purchase Orders. Hence the column (Work Order #) is PK in the table [Projects Database] which is linked to...

I would want to join the two tables .. that is why it is important that the values in the column (PurchaseOrderNo) in [Order Details] is filled up. For each (Purchase Order #) in the (Purchase_Order-Details) table, there would be some information which is present in the [Order Details] table...

Hello, I have two tables pertaining to the same database. Table [Purchase_Order_Details] amongst many fields have Columns - (Purchase Order #) which is the Primary Key and (Work Order #) My second table [Order Details] also has a column (Work Order #) . Now I have added another column to...

Well Galaxiom - well when did the changes you suggested, it broke the relationship which I had between "Projects Database" and the Query "Order Information". Is there any solution to this as well? Gemma - thanks a lot for the detailed reply. I think it might be difficult to get this sorted...

Dear all, Thank you for the response. Well I had thought earlier that I could avoid having the Composite Primary Key function by excluding the PO details from the "Projects Database" table. However this option wasn't working best for me since I have other reports / forms / excel files linked...

Hello, This is my first post on this forum. Hence in case i have missed out on guideline re posting messages, excuse me for the same. I needed some help re Composite Primary Key in Ms Access 2010. I shall try and explain my tables in detail. So my first table is "Client Database" where the...