see in your axcel file first creat tables, after that relationship, then queries wich i said, then creat forms, and two combo boxes (value save in field)
I think its better,
ok in queries,
[dailybook query] fields are head name, date, description, Dr., Cr., Total
[billquery] fields are head name, date, voucher#, Godown, quantity, rate, Total,
now i want to join these queries.
hello bharat,
first creat tables,
1 Farm Table
primery key on id
farm name text
2 suplier name table
primery key on suplier name
3 milk colection table
and creat relationship between them
and then creat forms
ok dear,
1st table Clintename, childtable Dailybook,
and
1st table Clintename, Childtable bill
now i want to see joint data in one query, the amounts of Dailybook and Bill how can i do this
please help me
thanks
ok dear,
1st table clintename, childtable dailybook,
and
1st table clintename, childtable bill
now i want to gather the amounts of dailybook and bill how can i do this
please help me
thanks
Thanks eugin u r great.
now i am facing a problem I made a software from daily book all the heads are maintain by entry of daily book but if i enter a bill that calculation is not shown in head detail how can i manage the two calculation in one head. please i want to thank you again.
regards
i want report with combobox i dont now about the vb please tell me how can i creat a combobox in or at report. so that i want to get report of my selected head or item.