Appending records to other records

[AVHer]

I am working on a database for my card collection and I was wondering if anyone knows how I can append one child record to a parent record. For example; if I get a buy a card one day and I already have that card entered into my database, I want to be able to just put in the cards information (the one I just bought) and then for quantity put 1. I want that record to be added to my other record with that same card info.

Before:
"This is a card" Quantity: 5

After
"This is a card" Quantity: 6



Thanks in advance!

[orange]

You might want to look at this model, if you are dealing with sports cards collecting.
http://www.databaseanswers.org/data_...ting/index.htm

[AVHer]

I already have a database built, I just want to know how to append records to other records.

[alansidman]

Why are you creating a new record. Why not open the original record and change the quantity? Create a look up/search/filter to determine if a record for that card already exists first. What is the unique identifier that is common for both cards?

Alan

[orange]

I already have a database built, I just want to know how to append records to other records.

What exactly does this mean?
You append records to a table. You could update a field as Alan has suggested.

The purpose of the data model was simply to give you something to "compare/test/confirm" your database/table structures. It wasn't meant to replace anything you have built.

[AVHer]

The problem is, I am entering hundreds upon hundreds of cards and I'm entering duplicates that I do not know I have duplicates of. It takes forever to type in the name of the card to find the already existing record, so I'd rather just type the entire card in and have it append to the already existing record. If there is a way to do that, please let me know!

[alansidman]

Instead of typing in the full name of the card and having duplicates, why not set up a custom filter. See below link and this will save you lots of time and energy.

http://www.datapigtechnologies.com/f...tomfilter.html

Alan