I'm try to make a simple database of the items we purchase in order to keep track of what each single user buys.
I made a table called Item where I will store items names, price, quote, invoice etc.
then I have a table with the list of users and their budgets.
What I was trying to do is just that every time I create a new record in the item table I specify to which user the item is "associate" and I was expecting to have in the user table a list of the items and the summary of the total price.
I made something that behave like this:
That is what I see in the user table:
|User01||Mr.x||I don't see anything||same, is empty|
|User02||Mr.x||As above||As above|
I related them with a relation:
Item table::UserIDfk >---User table:UserID
Allowing creation of data from the item table to the user table
The problem Is, indeed, when I create a new record in the item table I cannot associate it to a user that already exists, it creates a new user.
Still I navigate in the ocean, I can probably give you more informations if is needed.
What I would like to see instead is something like this:
User table (or a layout):
Is there anyone with a loot of patience that can help me please.
Thanks a lot!
but really , really, a lot.