Search results

I have check the data types. Both field are using Text data types but the index part got differences. 1 allow dupplications and another one doesn't allow. So what can I do? Thanks in advance~ Eli :)

Now i'm having another problem. I can manage run the Update query but the problem is when i check back the table that I update, it seems nothing to be updated into the table. Can you tell me what is the problem actually? Thanks in advance~ Eli :)

Hi there~ I try to update data from my Receipt query into Inventory table. But when I run the query, it gives me the error message as per attachment. Can anyone guide me on this and tell me what can I do? Thanks for your help in advance. Regards, Eli :)

Actually this is what I done. I use a queries and select few fields from 2 tables and save as Receipt. Then from this Receipt, I need to update the info into Inventory table. But when i run the update query, it gives me an error message as per attachment. Can you guide me on this and tell me...

Hi there.. I need some help on this problem I'm facing. I'm selecting Receipt No., Item Code, Quantity from Receipt table and wish to update the data into the same field in the Inventory table. What is the query I should write in order for me to achieve this? Thanks in advance~ Eli :)