Good day! Utter members, I'm newbei here and need some help for my current project I want to make a listing of Items in Tabular format, using multiple table how should I do it?

Here's my sample output:


form header
-------------------------------------------------------------------------------------
Item code Item Desc. Warehouse Qty Price Total Price
Location

details
-------------------------------------------------------------------------------------
0001 Pencil A 2 3.00 6.00
0002 Pen A 1 1.00 1.00
0003 Printer B 1 15.00 15.00
form footer
--------------------------------------------------------------------------------------
Grand Total -> 7.00

Tables
Warehouse
Fields Whrshe code, whshe desc

Item
Fields: Itmcode,Itmdesc,whreshe code, Qty, price

When I put it on a query and used a continuos form I can't Edit Qty fields , and I don't know why?

Hope you help me guys why I can't edit this fields, Thanks in advance!

- Cyber

Welcome to UA forums.

Is there a reason you use a query?

Can you update any other field?

I used query, but ican't update all fields when i put it to my form but when i open it to queries object it can. why this happened?

Thanks dough

Bind the form to your tables, not the query.

Not all queries are updateable; I am guessing you have a 1xM relationship between the tables.

You're guess is right, how do I bind them?

Use the form wizard.
After you select the two tables, it will give you an option for a form/subform or a single form (depends on the BY selection).

Play with is a bit and see which layout works for you.

HTH