Save me please!

[mithani]

hi friends!

I have four tables, tblSupplier, tblItem, tblinvoiceParent & tblinvoiceChild.

I want to design form where I can call my supplier name from supplier table.

Now i have to enter data for tblInvoiceParent, where I will save orderNo, orderDate, supplierID, deliveryDate. And for tblinvoiceChild, I think i must creat subform where I can enter multiple items, qty, rate.

I would apprecaite if anyone can send me similar form.

Thanks a lot

mithani

 

[Melaz29]

Create a query

Create a query using the fields you require and design a form based on the query.

post your db if you like and I will show you.