Hithank you..i will see and study, in the meantime, i attached my db sample, can you please take a look. I want to use the query as a source of my form (payment entry form)..
Hi mike60smartHi
Can you explain your business process in a bit more detail?
Your Relationship diagram shows a Buyer has Multiple LotDetails
Or should it show the Property has Multiple Buyers??
OKHi mike60smart
Yes buyer is possible to buy more than 1 lot within same block.. Property is not multiple buyer.
many thanks sir.. i will study the fixed db..OK
I deleted the query as it was of no use.
Study the relationship diagram in the attached and you will see that 1 Buyer can show an interest in Multiple Lots
The Form in the attached database consists of a Main form based on the tblBuyer table
with a Subform based on the tbLotDetails.
many thanks sir.. i will study the fixed db..
hi mike60smart,OK
I deleted the query as it was of no use.
Study the relationship diagram in the attached and you will see that 1 Buyer can show an interest in Multiple Lots
The Form in the attached database consists of a Main form based on the tblBuyer table
with a Subform based on the tbLotDetails.
thanks pare koy.. trying to learn ms access..another demo pare koy.
Sir Arnel, i want to use your demo, would it be possible to add search feature on a textbox with button on to the form, pls need your help.. I know to put the combo to search with the wizard, but most of the time the macro is corrupted.. My access is only 2007..another demo pare koy.
another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version
another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version.
Thank you so much sir arnel.. are u in pinas or other country..?another one, same tables, using datasheet subforms.
which search do you need, can you draw/snapshot of it.
the demo is A2007 version.
yes sir at baras rizal..pinas... and you?