Hi guys, I really need some help here. I am trying to create a little database for some invoice tracking.
So far I have 2 tables , Record and IndRecord, and all customer information are in Record and the ID will be the primary key
the IndRecord include ItemID ( not really needed , just for primary key ) , InvoiceID which is related to the ID in Record , item, amount etc.
So I want to make a report that when I click print in the form i created, let say i am on ID 12, i want to print the customer information along with all the items and amount from the IndRecord which has the same ID
For Example:
[ID]
[Name]
[Address]
[Phone]
[InvoiceID]
[Item] [Amount]
|| ||
[Item] [Amount]
(Like a list of items for ID 12 has bought )
so far for my sql understanding
it should be
select Item, Amount
from IndRecord I , Record R
where I.InvoiceID = R.ID, ( and R.ID = the number shown on my form)
And I got stuck, becuase I do not know how to create a report with only 1 ID and show all items belong to that ID from the IndRecord
I tried to create a Query but even so, after I create a blank report and use the query to display, it will still show up all the items from the IndRecord
I hope someone can explain for me , sorry for poor English ..